In VBA imbed system date in a file name - TechRepublic
General discussion
November 2, 2002 at 08:00 AM
watch4

In VBA imbed system date in a file name

by watch4 . Updated 23 years, 5 months ago

I am writing a very simple copy routine that is to capture a report for each day. I need to rename the file each time I copy it to a historic directory, so that the file name will include the File Name and the current system date. I have tried a number of things and although I can always get a file name + system date in a msgbox – I haven’t found the right syntax to actually name the file with that combination “Population Report 11/02/02”.

This discussion is locked

All Comments