Excel API for save as various format

[vbakan]

Could any one know the API Function used in Excel for "Save As" menu option. I want to convert Excel (.xls) in to .csv and .xml.

Please help me if you know a way in VBA. I am using Excel 2002.

 

[Chance1234]

ThisWorkbook.SaveAs
ThisWorkbook.SaveAsXMLData

Both of these take perimeters which you will see by pressing the F1 help

Chance,

F, G + _HH

 

[vbakan]

Thanks for your prompt reply. I don't get the ThisWorkbook.SaveAsXMLData


Any iead why Do I need any reference for that

 

[Chance1234]

ah sorry missed the 2002 bit ,

have alook at faq707-6257



Chance,

F, G + _HH

 

[vbakan]

Thanks again, I want the same method used in Excel Menue, as it has got xml scheme and style sheets as well incorporated. Would you know any think about it ?

 

[Chance1234]

have you recorded a macro and looked at the source ?

I only have 2003 on my machine at the moment so unable to check



Chance,

F, G + _HH

 

[vbakan]

I don't have the XML Menu in Excel 2002, SO I am unable to do the macro recording, Could you tell me how can I do that please.

 

[Chance1234]

Tools/Macro/Record new macro

go through the menus you want to then click stop, hit F11 and you can see teh code

Chance,

F, G + _HH