Hi all,

I need a bit of help understanding hyperlinks. I want to create a VBA
function that opens an Excel file from a hyperlink, and another function
that closes the same file (without saving changes).

What I have is a spreadsheet with a list of file pathnames, which is a named
range. A VBA macro opens each Excel file in the list, extracts some data,
then closes each file. Rather than requiring the list be composed of
pathnames, I would like to allow users to specify hyperlinks to files on
other servers.

If you can offer some advice or point me to examples I would greatly
appreciate it.

Thanks,

-- Rev