Access VBA

ResolvedVersion 2007

Wed 14 Mar 2012, 16:11 Delegate Louise said...

Louise has attended:
Access Advanced course
Access VBA course

If I required data to be exported to excel and a file created, how would I reference the date it is generated in the file name?

Thu 15 Mar 2012, 09:02 Trainer Anthony said...

Hi Louise. Simply concatenate the "Date" function to the end of the filename then TransferSpreadsheet out, as here:

http://www.pcreview.co.uk/forums/add-date-export-file-name-t3997246.html

Hope this helps,

Anthony

Thu 22 Mar 2012: Automatically marked as resolved.

Training information:

Access tip:

Press CTRL+SHIFT+ SEMICOLON

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back