Follow a hyperlink when clicking a command button in Excel

[vedicman]

I'm having trouble finding code that follows a hyperlink when clicking a command button in Excel. I want to go to this address:

\\bendixad\dfs\finance\JDE Reports\Cash Management\Cash Mgmt Integrity.exe

I can get to this page if I insert the hyperlink, then click on it, but I need to put it in the click event of a command button so that I can accomplish something else prior to following the hyperlink.

Any ideas?

Thanks.....Franco

 

[PHV]

Have a look at the FollowHyperlink method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886