Naming files using date string using OutputTo

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MH UK - 15 Dec 2005 10:36 GMT

I'm sure this is easy but, using the OutputTo command I am outputting several
queries as spreadsheets. That is so easy, even I can do it! What I am
struggling with is incorporating the current week number in the file name as
I export weekly and don't want to overwrite each file each week.
e.g. to name a file Sales_PerformanceWk46.xls where "46" will automatically
vary each week and thus become Sales_PerformanceWK47.xls next week.

Thanks,

MH

Reply to this Message

Graham R Seach - 15 Dec 2005 11:23 GMT

DoCmd.OutputTo acOutputQuery, _
"qryMyQuery", _
acFormatXLS, _
"C:\Temp\Sales_PerformanceWk" & DatePart("ww", Date) &
".xls"

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

> I'm sure this is easy but, using the OutputTo command I am outputting
> several
[quoted text clipped - 9 lines]
>
> MH

Reply to this Message

MH UK - 15 Dec 2005 11:41 GMT

Thanks Graham.
I was close but couldn't get the format right. I was placing " " incorrectly.

> DoCmd.OutputTo acOutputQuery, _
> "qryMyQuery", _
[quoted text clipped - 21 lines]
> >
> > MH

Reply to this Message