SaveAs Macro Help?

[NeuralNetwork]

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

 

[Ron de Bruin]

x1Text

Change to xlText

 

[Guest]

Dont you want a _ after .SaveAs?

 

[Andy Pope]

Looks suspiciously like a 1 (one) instead of a l (letter L) in the
FileFormat constant.

Try, FileFormat:=xlText

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

--

Cheers
Andy

http://www.andypope.info

 

[NeuralNetwork]

Endless Thanks! You have made my day!