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?

Also, how about the hyperlinks to webpages. How would I cache these? Or
would i be beter off copying these as well?

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