Is there a way to access 1 hyperlink and then after 15 second delay open another link in same window?
Is there a way to access 1 hyperlink and then after 15 second delay open another link in same window?
Last edited by Tortus; 09-22-2014 at 04:41 PM.
Maybe...
Sub Macro1() Application.OnTime Now + TimeValue("00:00:15"), "Macro2" End Sub
Sub Macro2() MsgBox "hello" End Sub
Sub DontForgetThese() If Your thread includes any code Then Please use code tags... If Your thread has been solved Then Please mark as solved... If Anybody has helped to you Then Please add reputation... End Sub
I played with this... it is sort of like yours. Problem is it opens another tab in Explorer. Not sure how to make that stop and open in the same window.
Sub Open_HyperLinks() Dim hl As Hyperlink Range("k1").Select For Each hl In Selection.Hyperlinks hl.Follow Next hl Application.Wait (Now + TimeValue("0:00:10")) Call Open_Hyper2 End Sub Sub Open_Hyper2() Dim hl As Hyperlink Range("l1").Select For Each hl In Selection.Hyperlinks hl.Follow Next hl End Sub
Got it! NewWindow=False was missing after the last hl.follow. Thanks everyone that looked. Maybe it will help someone else.
I have no idea opening in the same ie window.
I hope other forummates will help you about that point...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks