exporting table to excel but with date in name

Topic

New Reply

I have a macro that exports an access table to excel but I would like to an id number to the file name or todays date to the filename.

Richard

Reply | Quote

Replies

I’d use VBA code, macros are hard to maintain. You can use an expression in the file name, for example:

Dim strPath As String
Dim strFile As String
strPath = “C:Export”
strFile = Format(Date, “yyyymmdd”) & “.xls”
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, “tblTest”, strPath & strFileName, True

Note: you can’t use a date in the form 11/10/2009 in the file name, because slashes / aren’t allowed in file names.

Reply | Quote

I’d use VBA code, macros are hard to maintain. You can use an expression in the file name, for example:

Dim strPath As String
Dim strFile As String
strPath = “C:Export”
strFile = Format(Date, “yyyymmdd”) & “.xls”
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, “tblTest”, strPath & strFileName, True

Note: you can’t use a date in the form 11/10/2009 in the file name, because slashes / aren’t allowed in file names.

thanks again

Reply | Quote