Relink Excel Objects

H

Holger Gerths

Hi,

I want to relink an OLE-linked Excel - cell-range in PPT after the Excel
Workbook has been moved.

I try this way:

Sub Relink()
'assume that the excel file is in the ppt-folder
ActivePresentation.Slides(1).Shapes(1).LinkFormat.SourceFullName =
ActivePresentation.Path & "MyExcelWorkbook.xls!MySheet!R2C2:R13C6"
ActivePresentation.Slides(1).Shapes(1).LinkFormat.Update
End Sub

The result is that the whole worksheet is linked, not the specified
cell-area. Any idea?

Thanks in advance.
 

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

Similar Threads

Repeating my question that has not been answered until now: Relink Excel Range in PowerPoint 1
Visio to Excel 0
Links to Excel won't update in looping PowerPoint Show 0
Extracting data from Powerpoint datasheet/MSgraph to Excel 8
refresh data in embedded excel objects 1
VBA code to distinguish Links 1
using ppt and vba to open and print from excel 0
VBA for Dependents shortcut menu 0

Top