I have seen this done before in the past, like 4 years ago with Excel95, but
every attempt I have made to recreate this has failed. Please help.
I want to use a cell to enter my hyperlink location such as C:\Myfile or
www.google.com.
Now I want VB to look at the cell, lets say cell A1 has this hyperlink in
it, and perform the ActiveWorkbook.FollowHyperlink Address command to open
Windows Explorer, or Internet Explorer, to that location.
How do I get VB to follow a hyperlink that has been entered in a cell anf
then, if needed, opening the appropriate program like Windows Explorer or
Internet Explorer? Or could it be a different command?