Thread: Saving a woorkbook as a TXT file keeping its current name
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chichifo Chichifo is offline
external usenet poster
  
Posts: 1
Default Saving a woorkbook as a TXT file keeping its current name
I'm really new to macros and I want to use a macro for several exce
files. I need to save them at the end as a Text (Tab delimited)(*.txt
however I want to keep the original file name. How can I make Book1.tx
a variable so it will take the woorkbook name that the macro i
processing.

ActiveWorkbook.SaveAs Filename:= _
"C:\Documents and Settings\Book1.txt", FileFormat:= _
xlText, CreateBackup:=False
THX

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

Reply With QuoteReply With Quote