View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
DKS DKS is offline
external usenet poster
 
Posts: 103
Default Invoke hyperlink

Got it:

ActiveWorkbook.followhyperlink <string expression where string expression
must contain a valid URL.

But at this point I have another question:
if the string expression does not contain a valid url then how can we trap
this error programatically? i noticed that due to a bug in some case my
string expression did not contain a valid url, and despite having an ON ERROR
clause the routine did not trap the error. Any ideas?

"DKS" wrote:

in a module i have created a valid url address in a text field. I want to
"Follow" the created url. What is the best way to achieve that?