-
OLE Excel Object in PowerPoint - Works only once
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]
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules