Creating a New File

[Guest]

I'm exporting data from Access to excel. I have an append query that pulls
the info that I want to export, and I have a Macro that runs the export. I
was wondering if there was a way that Excel can automatically create a new
file everyday this process runs?

 

[John Nurick]

Try using an expression like this for the filename argument in the
macro:

="D:\Folder\File\FILE" & Format(Date(), "yyyymmdd") & ".xls"

 

[Guest]

John,
In the output file argument of the macro I have

\\lssmil001\grads\ssb_apps\development\inctrack3 & Format(Date(),â€yyyymmddâ€)
& “rd_export.xlsâ€

but it doesn't seem to work. Am I missing something?

 

[Ronald W. Roberts]

John,
In the output file argument of the macro I have

\\lssmil001\grads\ssb_apps\development\inctrack3 & Format(Date(),â€yyyymmddâ€)
& “rd_export.xlsâ€

but it doesn't seem to work. Am I missing something?

:

\\lssmil001\grads\ssb_apps\development\inctrack3 & Format(Date(),â€yyyymmddâ€)
& “rd_export.xlsâ€

Try this
"\\lssmil001\grads\ssb_apps\development\inctrack3" &
Format(Date(),â€yyyymmddâ€)

& “rd_export.xlsâ€

Note the quote as the first character and after inctrack3

Ron

 

[Guest]

Thanks for the help. I ended up coding it into the module instead of using
the Macro. The code you gave worked in the module. Thanks again
Nick