from a VB Macro how to save a excel worksheet as text file
Posted by Raja on December 19, 2000 11:16 AM
I need help to save an excel sheet as a plain text (either tab delimited or comma delimted) file.
This syntax is run as part of a VB Macro triggerred by a MS Outlook event.
I tried using the following syntax
mysheet.SaveAs FileName:="C:\RCK\DATA\IFILE.txt", FileFormat:=xlText, createBackup:=False
But it fails giving me an error like this..
1004 Save as Method of worksheet class failed
Would be thankful if anybody could suggest a way out.