Linking powerpoint to Excel

J

j

Hi,

I am trying to change the link in a powerpoint object
to a excel file through VBA. The excel file is just
created and not saved. The code follows:

For Each s1 In ppobj.ActivePresentation.Slides
For Each s In s1.Shapes
If s.Type = msoLinkedOLEObject Then
With s.LinkFormat
.SourceFullName = lspresdef & ".xls"
.Update
End With
End If
Next
Next

This gives an error in sourcefullname. If i give a saved
filename with full path it works fine. Can someone help me
in changing the link to an unsaved excel file??
 
K

Kurt

I think the problem is due to your unsaved excel file. When you link to a
file, the file should exist.
Maybe have a look at www.take-off.as/datapoint
There you'll find a powerpoint addon that links powerpoint dynamically to
text files, databases and excel files.
Kurt.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top