I’ve tried them all, but I can’t get it to work.
I have a list of URLs in Excel that I have to open asynchronously but otherwise the server will ban me.
I use this macro:
Sub OpenHyperLinks()
Dim xHyperlink As Hyperlink
Dim WorkRng As Range
On Error Resume Next
xTitleId = "OpenHyperlinksInExcel"
Set WorkRng = Application.Selection
Set WorkRng = Application.InputBox("Range", xTitleId, WorkRng.Address, Type:=8)
For Each xHyperlink In WorkRng.Hyperlinks
xHyperlink.Follow
Next
End Sub
but the problem of this macro which opens all the URLs present in Excel at the same time (and there are over 1000 of them) consequently causes a system crash. I need this, or a similar macro, instead of opening all the URLs in Excel immediately, to open them one at a time with a delay of, for example, 10 seconds.
Example:
URL: 1-2-3-4-5-6-7-8-9-10
When I start the macro I’m using now, it opens them all at the same time, while I would like it to:
URL: 1-2-3-4-5-6-7-8-9-10
are opened with a delay of 10 seconds (1 after 10 seconds 2 and so on)
Unfortunately I can’t find a solution =( Is there anyone who has already faced the problem and can help me find the right macro or modify this one?
A thousand thanks
As indicated in the message of my problem, I hope someone can find the right solution, unfortunately I tried them all, but I couldn’t.
DjTribunus is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.