SaveAs Macro Help?
 

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


---
Message posted from http://www.ExcelForum.com/

SaveAs Macro Help?
 

x1Text

Change to xlText

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"NeuralNetwork" wrote in message ...
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


---
Message posted from http://www.ExcelForum.com/

SaveAs Macro Help?
 

Dont you want a _ after .SaveAs?



-----Original Message-----
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


---
Message posted from http://www.ExcelForum.com/

.

SaveAs Macro Help?
 

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

Try, FileFormat:=xlText

NeuralNetwork wrote:

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


---
Message posted from http://www.ExcelForum.com/


--

Cheers
Andy

http://www.andypope.info

SaveAs Macro Help?
 

Endless Thanks! You have made my day!


---
Message posted from http://www.ExcelForum.com/