Creating a New File

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
Try using an expression like this for the filename argument in the
macro:

="D:\Folder\File\FILE" & Format(Date(), "yyyymmdd") & ".xls"
 
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?
 
nmarano said:
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?

:
Click to expand...

\\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
 
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
 
Back
Top