want to activate hyperlink, but dont open ...

[suvaline]

I dont know much about VBA, but maybe somebody can help me ;)
I have this kind of SUB ..

Sub kama2()
    Worksheets("kama").Activate
    Range("A51").Select
    Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True
    Application.WindowState = xlNormal
    Start_Timer
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!

[puppydogbuddy]

I believe that using the followhyperlink method with a workbook object defaults to the open window and does not open a new window:

ActiveWorkbook.FollowHyperlink "http://www.microsoft.com"
 

Hope this helps.