View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Robert Gelbmann Robert Gelbmann is offline
external usenet poster
 
Posts: 4
Default Hyperlink programing question

Hi Stranger! (How about a real name?)

---"SJW_OST" schrieb ...
I have seen this done before in the past, like 4 years ago with
Excel95, but
[...]
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?


(1) Hyperlinks have been introduced with Office 97?!

(2) Try something like this:

Range("A1").Hyperlinks(1).Follow


Greetings from Vienna, Austria,
-Robert Gelbmann-