Hi
This works:
ActiveWorkbook.SaveAs Filename:= _
"C:\Documents and Settings\Pierre\Mes documents\Book1" & Day(Now()) & Month(Now()) & Year(Now()) & ".txt", FileFormat:= _
xlText, CreateBackup:=False
Many other free tips on
http://www.excel-vba.com
Quote:
Originally posted by FuzzyLogic
Can anyone help me debug this section of code?
today = Format(Now, "ddmmmyy")
ActiveWorkbook.SaveAs Filename:="F:\folder\my_file_" & today & ".txt", FileFormat:=x1Text, CreateBackup:=False
I'm stumped
|