By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,134 Members | 1,931 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,134 IT Pros & Developers. It's quick & easy.

want to activate hyperlink, but dont open ...

P: 1
I dont know much about VBA, but maybe somebody can help me ;)
I have this kind of SUB ..
Expand|Select|Wrap|Line Numbers
  1. Sub kama2()
  2.     Worksheets("kama").Activate
  3.     Range("A51").Select
  4.     Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True
  5.     Application.WindowState = xlNormal
  6.     Start_Timer
  7. End Sub
... and question ...
I need to activate hyperlink( to IE), but dont open new window. I use WebQuery and if the macro will run an hour, it maybe opens 100 new windows :D
... or how to write, that after opening the new window will close!
Sep 30 '08 #1
Share this Question
Share on Google+
1 Reply


puppydogbuddy
Expert 100+
P: 1,923
I believe that using the followhyperlink method with a workbook object defaults to the open window and does not open a new window:
Expand|Select|Wrap|Line Numbers
  1. ActiveWorkbook.FollowHyperlink "http://www.microsoft.com"
  2.  
Hope this helps.
Oct 2 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.