APPENDING DATE AND TIME TO FILE

[jrp444]

I need to export a table that I build back to windows, but I need the name of
the file to have the date & time. Is there a way to do this?????

 

[Klatuu]

Assuming you are programmatically using TransferSpreadsheet, TransferText,
etc, you can build the file name with the date and time:
Dim MyFileName as string
MyFileName = "C:\SomeFolder\MyFileName" & _
Format(Now(), "yyyymmddhhmmss")

 

[jrp444]

Thanks!

Assuming you are programmatically using TransferSpreadsheet, TransferText,
etc, you can build the file name with the date and time:
Dim MyFileName as string
MyFileName = "C:\SomeFolder\MyFileName" & _
Format(Now(), "yyyymmddhhmmss")