View Single Post
  #1   Report Post  
Philj Philj is offline
Junior Member
 
Posts: 2
Default Setting links to relative paths from ppt to xls

I have a powerpoint linked to parts of 20 speadsheets.
In Office 2000, when I move the files to a different machine, ppt's update links says it can't find the links (a familiar story, except with a powerpoint twist).
(BTW: XP seems to find its way just fine).

I need a ppt macro just like ChangeQuerySources that sets the ppt links to the linked Excel objects to a relative path. I think it's the same code except I don't know the name of the ppt object that would be used instead of QueryTable.

Your help is greatly appreciated.