VBA: Manipulate Workbook Object?

[Minh]

Hello!

I have a workbook object embedded in slides 3 through 5 of a PP. Could
someone please provide me with some code to automatially update the first
cell of the first worksheet of each of the workbooks in each of the slides?
I just need to update the date in the first cell (A1) to the current date.
Each slide only has a textbox and the workbook object. I appreciate the help!

Minh

 

[Minh]

Nevermind. I figured it out.

My code was:

With ActivePresentation.Slides(i).Shapes(2).OLEFormat

It should have been:

With ActivePresentation.Slides(i).Shapes(2).OLEFormat.Object

Thanks!
Minh