I need to save a xls file as csv.
When I save it manualy by using saveas, and choosing csv format in the drop
down box, everything is OK.
But when I try to program it in VB, all the data is put in column A.

Can anybody help?

Hi,

did you try macro recorder?

Regards,
Ivan

Hi

Yes. When i juse the recorder, all the data is arrangende in column A
Regards Fib

"Ivan Raiminius" skrev:

Hi,

did you try macro recorder?

Regards,
Ivan

Hi,

so, you are using:

workbooks("some workbook").SaveAs Filename:= _
"some filename(including path).csv" _
, FileFormat:=xlCSV, CreateBackup:=False

in your code?

Regards,
Ivan

Hi
My code is:
Windows("record.xls").Activate
ActiveWorkbook.SaveAs "F:\record.csv", FileFormat:=xlcsv

I have tryed this one as well, but havent been able to create the same
format, like the format when I am saving it manualy.

Windows("record.xls").Activate
Const xlcsv = 1 '(I have tryed every number from 1 to 100. )
ActiveWorkbook.SaveAs "F:\record.csv", FileFormat:=xlcsv

Best regards Fib

"Ivan Raiminius" skrev:

Hi,

so, you are using:

workbooks("some workbook").SaveAs Filename:= _
"some filename(including path).csv" _
, FileFormat:=xlCSV, CreateBackup:=False

in your code?

Regards,
Ivan

Hi,

xlcsv = 6

your code should work. What is the exact problem? What do you see when
you open your .csv file in Notepad? and in Excel?

Regards,
Ivan