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.
|