Celletje1974

Guys (Girls?),

I have found some code on this forum that works great to open a website from VBA, but since it does refer to Internet Explorer, I suppose it will not work if the user of my spreadsheet does have a different webbrowser on his/her computer than IE. Is there a universal way to open a website from within VBA with "the standard program associated with the .html file extention" or something?

The code I am referring to is:

Sub VisitWebsite()

Dim ie As Object
Set ie = CreateObject("INTERNETEXPLORER.APPLICATION")
ie.NAVIGATE "http://websiteaddress"
ie.Visible = True

While ie.busy
DoEvents
Wend

End Sub

hulett819

You can use the ShellExecute API command.

http://www.xtremevbtalk.com/show...t=shellexecute shows how it was done with a PDF document.

The actual specs of the API can be found http://www.mentalis.org/apilist/ShellExecute.shtml as well as example programs in VB that are easy to implement.

--hulett

Celletje1974

Hulett, thanks! The combination of both links made it clear to me.

Thanks,

Marcel

herilane

One could of course just take the easy road and just use Excel's built-in capabilities - see Insomniac's post in this thread

Celletje1974

That's a beauty That must be the thing I've been looking for, but could not find... This has become the one-line-solution:

ThisWorkbook.FollowHyperlink Address:="http://www.mysite.nl", NewWindow:=True

Thanks!

Marcel