Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel hyperlinks - 30 second pause!

Status
Not open for further replies.

ptj

Programmer
Oct 5, 2001
46
0
0
GB
Hello all

I have a weird issue with Excel - when I click on a link to a web address Excel pauses for about 30 seconds before opening the browser.

The cell contents:
I've also tried the '=hyperlink' function with the same result.

If I use this code:

Sub LaunchIE()
Dim IE As Object
Set IE = CreateObject("InternetExplorer.Application")
IE.navigate " IE.Visible = True
Set IE = Nothing
End Sub

it opens instantly.

The same link on a colleague's computer works fine - fast (although not as fast as the vba code).

Any bright ideas?

Thanks in advance!

Phil
 
Antivirus/firewall issue? Maybe trying to scan the target if you don't instantiate the browser from code?

Beir bua agus beannacht!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top