Using VBA, how do I export Excel file as a CSV?

[hollifd]

Using VBA, how do I export Excel file as a CSV file? All help or comments will be appreciated.

Thanks,

David

 

[tactps]

I assume by "export", you want to save the file as a CSV. If so update this code:

ActiveWorkbook.SaveAs Filename:= _
"c:\MyFile.csv", FileFormat:=xlCSV _
, CreateBackup:=False

Regards

 

[hollifd]

tactps,


That works really good.

Thanks for your help.

David

 

[shornco]

I'm assuming the process would be the same if you wanted to go the other way: a CSV file to an XLS file. I tried this to no avail:

ActiveWorkbook.SaveAs Filename:= _
"c:\MyFile.xls", FileFormat:=xlXLS _
, CreateBackup:=False

I wasn't sure on what the FileFormat would be named, I think that's where my problem lies. Any ideas?

Thank you.

 

[tactps]

FileFormat:= _
xlNormal

Silly of people to think that there would be any logic in file extentions! lol

Note - laughing at Excel, not you

 

[z4x3r]

Hello guys,

When I automate a process to save an excel file to a csv the resulting csv has not Its data formatted into different columns (how I want it) but delimited with commas.

If I do the process I coded manually (by "saving as") It prompts me a message saying something that I may los some data but It does what I want... If I record that into a macro I get the usual code that you are discussing here, that doesn't do what I want

Any ideas?

 

[scanavan10]

I have a similar problem. When I manually save an xls file into CSV, the date format is maintained, when I use the same macro code, dd/mm/yyyy is changed to mm/dd/yyyy which I cannot use.

Any suggestions?

 

[Richard Schollar]

Hi

I wrote a couple of functions to export ranges of text to new text files (including csv files) which avoids this problem - see post #18 in the following thread for a demonstration of these:

http://www.mrexcel.com/forum/showthread.php?t=456803&page=2

 

[scanavan10]

Thank you,

I'm moving jobs soon and there aren't allot of people who would understand that code if it broke. My crude but effective solution for now is to change the date format from 01/06/2010 to 01.06.2010. Seems to work.

Thanks for the help.

Stephen

 

[dadario]

this csv file can be saved as Utf-8 ?