Opening a webpage from a vba macro in excel

[Irishmaninusa]

Hi Everyone,

Is it possible to open a website from within a macro in Excel....if so...how
would you do that?

And please...don't laugh.....

 

[John Eppley]

I have been using the following routine for several months. The sub routine
was found on this newsgroup, and I do not know who deserves the credit.


Sub OpenMyChoiceWebSite()
ThisWorkbook.FollowHyperlink Address:="https://www.MyChoice.com/"
End Sub

Replace MyChoice with your choice.

Hope this helps.

John Eppley