I need to export a view to Excel with a date stamp, i have the following code but how do I add the date stamp?
'Get Export File
fileNum% = Freefile
Open "M:\Professional Services\Hotel Confirmations\2010\HotelBookings.csv" For Output As fileNum%
I need to export a view to Excel with a date stamp, i have the following code but how do I add the date stamp?
'Get Export File
fileNum% = Freefile
Open "M:\Professional Services\Hotel Confirmations\2010\HotelBookings.csv" For Output As fileNum%
Subject: what do you mean by date stamp?
The file you write to will automatically be stamped by the OS as being modified at the current date and time. If that’s not what you mean by a date stamp, can you please be more specific what you’re trying to do?