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.