Error closing embedded Excel workbook in PowerPoint

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an embedded Excel workbook in PowerPoint. I would like to save the
workbook but I get an error message.

Here is what the code looks like:

PowerPoint.OLEFormat oleFormat = shape.OLEFormat;
oleFormat.Activate();
Excel.Workbook workbook = (Excel.Workbook)oleFormat.Object;

string fileName = "c\\temp\\text.xls";
workbook.Close(true, fileName, missing);

Is it possible to save the embedded Excel workbook to file? Is so, what's
the best way to do it?

Thanks
 
I have not done this with Powerpoint but in Word. I can save the embedded
worksheet as follows:

ActiveDocument.InlineShapes(1).OLEFormat.Activate
ActiveDocument.InlineShapes(1).OLEFormat.Object.SaveAs "c:\xx2.xls"

Note: The index of InLineShapes may vary ( I have only one embedded object).
The embedded Excel object cannot be saved unless it has been ActivateED.
 
Back
Top