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.Sa veAs "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.

"Gail Hurn" wrote:

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

That didn't work in PowerPoint. SaveAs throws an exception.


"AA2e72E" wrote:

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.Sa veAs "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.

"Gail Hurn" wrote:

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