Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 save compatibility issue
Hi All,
I've been running into saving the excel workbook in compatibilty mode issues with automation. Steps a Open Excel 2007: Now i go to the office button on the top left and set the options to save in office 97-2003 format. Now you cannot add more than 256 columns of data. close the Excel. Automation code with me something like this: CLSID clsid; HRESULT h = CLSIDFromProgID(L"Excel.Sheet", &clsid); // some more stuff here h = ::OleCreate(clsid, IID_IOleObject, OLERENDER_NONE, NULL, site, context-storage, (void **) &oleObject); // some more stuff here h = ::OleRun(oleObject); oleObject-DoVerb(OLEIVERB_OPEN, NULL, context-site, 0, NULL, NULL); This will bring up the Excel 2007 and set it running. Now if you check the save options it will still show the saving format at .doc but will gladly allow you to add more than 256 columns of data. And now if you save it will not save in .doc format. Please let me know if I'm missing something here. Thanks in advance, Sarang Baheti. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 save compatibility issue
On May 14, 12:00 pm, Sarang wrote:
Hi All, I've been running into saving the excel workbook in compatibilty mode issues with automation. Steps a Open Excel 2007: Now i go to the office button on the top left and set the options to save in office 97-2003 format. Now you cannot add more than 256 columns of data. close the Excel. Automation code with me something like this: CLSID clsid; HRESULT h = CLSIDFromProgID(L"Excel.Sheet", &clsid); // some more stuff here h = ::OleCreate(clsid, IID_IOleObject, OLERENDER_NONE, NULL, site, context-storage, (void **) &oleObject); // some more stuff here h = ::OleRun(oleObject); Actually here the launching Excel process fails with error code 0x80030002(STG_E_FILENOTFOUND) Also I'm trying to open a xlsx file thru structured storage file. Is this valid? This code works perfectly fine on machine where Excel2007 is installed and I'm trying to run Excel2007 workbook thru OleRun. Also I have installed compatibility pack on top of Office 2003 so that it opens any of Office2007 files correctly. oleObject-DoVerb(OLEIVERB_OPEN, NULL, context-site, 0, NULL, NULL); This will bring up the Excel 2007 and set it running. Now if you check the save options it will still show the saving format at .doc but will gladly allow you to add more than 256 columns of data. And now if you save it will not save in .doc format. Please let me know if I'm missing something here. Thanks in advance, Sarang Baheti. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 compatibility issue - speed between cells | Excel Discussion (Misc queries) | |||
EXCEL 2007 COMPATIBILITY MODE ISSUE | Setting up and Configuration of Excel | |||
excel 2007 compatibility issue | Excel Discussion (Misc queries) | |||
Excel 2007 Color Backward-Compatibility Issue | Excel Discussion (Misc queries) | |||
Office 2007 Compatibility Pack issue? | Excel Worksheet Functions |