APPENDING DATE AND TIME TO FILE

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

Guest

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?????
 
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")
 
Thanks!

Klatuu said:
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")
Click to expand...
 
Back
Top