Tue 9 Sep 2008, 16:35Delegate Greg said...
Greg has attended:
Excel VBA Intro Intermediate course
Excel VBA Intro Intermediate course
MS Excel
How can I convert an Excel Worksheet list of comma separated values to a tab delimited version?
Thu 11 Sep 2008, 11:37
Edited on Thu 11 Sep 2008, 11:38Trainer Carlos said...
RE: MS Excel
Hi Greg
The code below opens an existing (.csv) document in Excel and then saves it as a new (.txt) document
Sub ConvertWorkbook()
Workbooks.Open Filename:= "D:\Documents and Settings\TrainerDev07\Desktop\Sales 2004.csv"
ActiveWorkbook.SaveAs Filename:= "D:\Documents and Settings\TrainerDev07\Desktop\TXTSales 2004.txt", _
FileFormat :=xlText, CreateBackup:=False
End Sub
Hope this helps
Carlos
