BorlandTalk.com

Brian Lonnon · Guest

Hi,

I need to be able to open Excel 2003 from my app, load a .xls file and save
it as an xml file. The first two parts I can do, but I can't save the file
AS in xml spreadsheet format. Can anyone help please?
Variant excel;
excel.OlePropertySet("Visible", false);
Variant book = excel.OlePropertyGet("Workbooks");
book.OleFunction("Open", OpenDialog2->FileName.c_str());
Variant application = excel.OlePropertyGet("Application");
book = excel.OlePropertyGet("Workbooks", 1);

//problems with these 2 lines
book.OlePropertySet("SaveAsType", "xlXMLSpreadsheet");
book.OleFunction("SaveAs","c:\\text1.xml");

book.OleFunction("Close");
excel.OleFunction("Quit");

Thanks

Brian