A CSV file uses commas as delimiters
Activesheet.copy
Application.DisplayAlerts = False
ActiveWorkbook.SaveAs "C:\Myfolder\Myfile.txt", xlText
Application.DisplayAlerts = True
Activeworkbook.Close SaveChanges:=False
--
Regards,
Tom Ogilvy
"Sandeman" wrote:
Hello. I would like a macro to save a worksheet as a .csv file in a
folder on my C drive. The worksheet will vary in size (rows and
columns). The sheet must use tabs as a delimiter.
Thanks for your help!
--
Sandeman
------------------------------------------------------------------------
Sandeman's Profile: http://www.excelforum.com/member.php...o&userid=32440
View this thread: http://www.excelforum.com/showthread...hreadid=529220