Refreshing embedded excel

[Guest]

I have been creating Powerpoint 2007 presentations by creating slides via the
packaging dll available with Office 2007. One of the problems I initially
ran into was when embedding excel sheets, the image that represents the sheet
would be the original one I had in my template presentation. It was only
when I used the interop via C# and did this line of code:

Microsoft.Office.Interop.Excel.Workbook workbook =
(Microsoft.Office.Interop.Excel.Workbook)shape.OLEFormat.Object;

... would the image update. The problem now is, I get a new image, but it is
skewed. If I double click the embedded excel, and unselect it, it updates
the image to be non skewed. I am wondering how I do this via interop. Can I?

 

[Guest]

Ok - I was able to activate the OLE object with

shape.OLEFormat.Activate();

and this refreshes the excel. I just need to figure out how to deselect it.

 

[Guest]

Figured out my problem:

_pptApp.ActiveWindow.Selection.Unselect();