Sleeper: Open web browser with specific address

[ilyaskazi]

i need to launch iexplore with specific address from excel through vba.

also with Opera or Mozilla.

[johnske]

Hi, probably the simplest way is with a coded hyperlink E.G.


'<< OPEN A WEB PAGE >>
Sub OpenWebPage()
On Error Goto 1
ActiveWorkbook.FollowHyperlink "http://www.vbaexpress.com/portal.php", NewWindow:=True
Exit Sub
1: MsgBox Err.Description
End Sub

Alternatively,


Option Explicit

Sub BeamMeUpScotty()
Dim ie AsObject
Set ie = CreateObject("InternetExplorer.Application")
On Error Goto 1
With ie
.navigate "http://www.vbaexpress.com/"
.Visible = True
End With
Set ie = Nothing
Exit Sub
1: MsgBox Err.Description
ie.Quit
Set ie = Nothing
End Sub

HTH,
John

[ilyaskazi]

working perfect with internet explorer. thankyou.

But I also need some website to open with different web browser ...i.e. Mozilla & Opera.

[Ivan F Moala]

working perfect with internet explorer. thankyou.

But I also need some website to open with different web browser ...i.e. Mozilla & Opera.

To do this you can use the shellexercute API.

See here http://www.xcelfiles.com/ShellExecuteA.html