Excel 2010 Save as CSV

[Mike_e]

Hi,

I'm in the process of amending macros to run in 2010. the main thing I'm struggling with is saving as CSV format. Here's the code I have which creates a file with a csv extension, but isnt in csv format.

With ActiveWorkbook
        .SaveAs Filename:=MyPath & MyFilename & ".csv"
        .Close
    End With

I'm guessing there must be an explicit command that dictates the file type but I'm having no success finding it

Can you help please?

M

[patel45]

did you see the help page of workbook.saveas method ? ther'is the FileFormat parameter

[Mike_e]

Many thanks, is that a help page in excel or the vb editor?

[patel45]

you can find it on vb editor or you can make a search with google with excel vba workbook.saveas