Force IE, not Netscape, to open hyperlink

K

Krupa

New Member

Joined

Oct 7, 2002

Messages

8

• Oct 11, 2002

• #2

Hey,

I don't know how you can set the default browser, but you can change the hyperlink into a button a run the following code


Public Sub GotoWebpage_Click()
Dim EXP

Set EXP = CreateObject("InternetExplorer.application")
EXP.Visible = True
'put the webpage here
EXP.Navigate ("http://www.mrexcel.com")
End Sub

HopeThishelps,
Krupa

 

Upvote 0

G

GMBJames

New Member

Joined

Aug 21, 2002

Messages

22

• Oct 11, 2002

• #3

Krupa,
thank you so much. This is exactly what I needed.
Jamie

 

Upvote 0

H

Hawk123

Board Regular

Joined

Jun 15, 2003

Messages

94

• Aug 13, 2003

• #4

is there a way to ensure that internet explorer is maximized?

 

Upvote 0

TommyGun

MrExcel MVP

Joined

Dec 9, 2002

Messages

4,202

• Aug 13, 2003

• #5

Why not just use the shell command...

Code:

Shell "Explorer ""www.mrexcel.com""",vbMaximizedFocus

 

Upvote 0

H

Hawk123

Board Regular

Joined

Jun 15, 2003

Messages

94

• Aug 13, 2003

• #6

I cant use the shell command because the length of the site im using is too long so it is getting cut off

 

Upvote 0

TommyGun

MrExcel MVP

Joined

Dec 9, 2002

Messages

4,202

• Aug 13, 2003

• #7

How long is the site???

 

Upvote 0

H

Hawk123

Board Regular

Joined

Jun 15, 2003

Messages

94

• Aug 13, 2003

• #8

https://xxxxxx.xxxx.xx.xxx/os/cgibi...&SID=" & sessionid & "&selView=shipment&win=1

 

Upvote 0

TommyGun

MrExcel MVP

Joined

Dec 9, 2002

Messages

4,202

• Aug 13, 2003

• #9

Yeah, that is a little long.

 

Upvote 0

S

sfarnsworth

New Member

Joined

Aug 25, 2002

Messages

3

• Feb 2, 2004

• #10

Hi. I saw this subject (actually I searched for it) and was VERY excited.

I've had this (similar) problem personally for a long time. I've tried to fix it (even just for me) but with no luck.

My problem is that when I use =Hyperlink(what, "label") it works, but it invokes Netscape. It doesn't do it very gracefully and thus I'd like to have IE be my default.

Actually IE IS my default browser, so I'm confused. If I launch Windows Explorer and find a .html or a .htm file and double click to launch it, IE launches. Thus little ole' me would think that IE IS my default browser for .html or .htm web pages. Thus I'm confused as to why Excel wants to apparently look elsewhere for figuring out my preference WRT browsers.

Thanks in advance for any help!

 

Upvote 0