I have a query related to the above.

I want to do exactly as above to create a log file, but my problem is naming the file using a string made up of "backup" and the date, i.e. backup22.09.2000.txt.

I've tried:

strFileName = "backup" & Date & ".txt"

Open "C:\Temp\strFileName" For Output As #1 and


Open "C:\Temp\"strFileName"" For Output As #1

but neither work. Can you help me on the correct syntax please?