Tech Support Forum banner
Cancel

Click excel hyperlink with vba

28744 Views 3 Replies 2 Participants Last post by  David M58, 
R
I have a excel hyperlink that is generated by code and i want to be able to click the link with vba or a macro and follow it. I have tried recording a macro but it follows to a specific cell and as the hyperlink address keeps changing this doesn't work

thanks
rslc
Save
Like
Status
Not open for further replies.
1 - 4 of 4 Posts
D
For example, if cell A1 contains one hyperlink that points to http://www.google.com/, you can then launch Google in your browser with this statement:

Range("A1").Hyperlinks(1).Follow
Save
Like
R
Thanks for the reply but the link i want to click points to an excel cell on another worksheet that i want to go to and using your code results in hi-lighted error in vba code module
Save
Like
D
You may find it necessary to specify additional qualifiers, such as the worksheet name in this line:
Worksheets("Sheet1").Range("A1").Hyperlinks(1).Follow
This may take some experimentation with the Follow method of the Hyperlink object.
Save
Like
1 - 4 of 4 Posts
Status
Not open for further replies.
Tech Support Forum
A forum community dedicated to tech experts and enthusiasts. Come join the discussion about articles, computer security, Mac, Microsoft, Linux, hardware, networking, gaming, reviews, accessories, and more!
Full Forum Listing
Explore Our Forums
Windows XP Support Windows 7 , Windows Vista Support Motherboards, Bios|UEFI & CPU Networking Support Laptop Support
Top