• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Help with VBA ! How to open the default browser with a specified url in windows/Mac machine from Excel VBA

S

Sarvesh1993

New Member
Hi Guys,

I am working on a VBA Excel Project ,the excel will be used in windows as well as Mac Machine .My requirement is to open the default browser in both machines ,the VBA should automatically figure out default browser configuration and should launch . Can someone help with the code
 
There's no such code unfortunately. As most standard object manipulation library available in Windows machine isn't available in Mac.

As well, many 3rd party browsers don't expose control to VBA directly.

Typically, what you will need is some sort of wrapper (such as Selenium) and leverage that in VBA.

Personally, I'd just go with Python or some other platform independent interpreted language for such tool/code.

EDIT: Oh I thought you needed to manipulate browser....
If it's not required to manipulate after initial launch. You can just use Hyperlink.Follow method.

Ex:https://docs.microsoft.com/en-us/office/vba/api/Excel.Hyperlink.Follow
 
You must log in or register to reply here.
Back
Top