View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gail Hurn Gail Hurn is offline
external usenet poster
 
Posts: 13
Default Error closing embedded Excel workbook in PowerPoint

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