Date File Extension

[NeonSky via AccessMonster.com]

Hello All,

Would one be so kind as to tell me how to assign the present date to the end
of a file name when exporting a query to a .xls file as run in a macro?

Thanks!

 

[Ken Snell \(MVP\)]

Use an expression as the File Name argument in the macro:

="C:\MyFolder\QueryName" & Format(Date(),"mmddyyyy") & ".xls"

 

[NeonSky via AccessMonster.com]

Thanks Ken!

Use an expression as the File Name argument in the macro:

="C:\MyFolder\QueryName" & Format(Date(),"mmddyyyy") & ".xls"

Hello All,

[quoted text clipped - 3 lines]

Thanks!