View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
NeuralNetwork NeuralNetwork is offline
external usenet poster
 
Posts: 1
Default 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/