Export to Excell with Date Extention

[cjaaron]

I'm trying to write a Macro to export a table to Excel. I want to name the
file so it has the current date in the file name (date the file is created or
Macro is ran) i.e. "AccessReportFile 20061026.xls".

I can't find this anywhere in Access or Excel help menu.

 

[Steve Schapel]

Cjaaron,

="C:\FolderName\AccessReportFile " & Format(Date(),"yyyymmdd") & ".xls"

 

[cjaaron]

Steve, I still can't get a table to export to an Excel table with date in the
Excel File Name. I also tried Transfere Spreadsheet command - no luck...
Here is my file name: T:\REPORTS\Affordable Housing Contracts
"&Format(Date()," mm-dd-yy") &".xls

I receive Failure Creating File error message.

TIA for your help!

 

[Steve Schapel]

Cjaaron,

You'll need to do it in the format I suggested. Your example is missing
the = and missing some "s and missing some spoaces and has another space
in the wrong place. Like this:
="T:\REPORTS\Affordable Housing Contracts " &
Format(Date(),"mm-dd-yy") & ".xls"

Yes, TransferSpreadsheet is the way to go, I'd say.

 

[cjaaron]

WOW HOOO! THANKS!!!!

cjaaron

Cjaaron,

You'll need to do it in the format I suggested. Your example is missing
the = and missing some "s and missing some spoaces and has another space
in the wrong place. Like this:
="T:\REPORTS\Affordable Housing Contracts " &
Format(Date(),"mm-dd-yy") & ".xls"

Yes, TransferSpreadsheet is the way to go, I'd say.