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
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