MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Comman Delimated Text File

  Asked By: Kevin    Date: Nov 25    Category: MS Office    Views: 1601

Can any one please tell me how to i convert excel file into comma delimated
text file thru VBA code?



1 Answer Found

Answer #1    Answered By: Hababah Younis     Answered On: Nov 25

I created this with the macro recorder...

ActiveWorkbook.SaveAs Filename:= _
"C:\Documents and Settings\Me\Mijn documenten\Book1.csv",
FileFormat:= _
xlCSVMSDOS, CreateBackup:=False

This does alter the name of the current worksheet though to dodad.csv so
you may want to save it as an ordinary excel file  to "convert" it back. I
was able to read the csv file in notebook after I'd released it from Excel.

Not tried it in a procedure though so let us know if it breaks and we'll
have another look.

Didn't find what you were looking for? Find more on Comman Delimated Text File Or get search suggestion and latest updates.