String manipulation and creating an "offline" excel workbook
 

I have an excel workbook that has a number of hyperlinks to files that
are on file systems external to my laptop. These are mostly PowerPoint
slides that reside on network shares. I also have a fair number of
hyperlinks that point to web pages.

I want to be able to make a copy of this workbook and run some VB
against the copy, that will copy all the targets of the hyperlinks to a
local directory on my laptop, and then update the hyperlinks to reflect
the new locations. In this way I could create an "off-line" copy of
my workbook.

How difficult or easy would this be?

Ex.

Where hyperlink=/some-mount-point/some-directory-path/some-file.ppt
I want to copy /some-mount-point/some-directory-path/some-file.ppt
To /some-local-directory/some-file.ppt
Update hyperlink=/some-local-directory/some-file.ppt

-barton