Hi,

I would like to automate embedding excel file in my powerpoint. And it worked for me, but only once. If i rename the file and the path in the vba then it works again (once).

[Q1] Is there some caching or locking ongoing for excel? In case of a pdf-file the problems is not visible.

[vba code:

Sub embed_excel()


Dim osld As Slide
Set osld = ActivePresentation.Slides(1)
osld.Shapes.AddOLEObject Left:=100, Top:=10, Width:=100, Height:=100, FileName:="c:\temp\test5.xlsx", DisplayAsIcon:=msoTrue, IconLabel:="Example-Caption"


End Sub]