Note: When you use Application.ActiveWorkbook.Path in your VBA code, it will return a string that represents the directory location (folder path) where the active workbook is currently saved or located on your computer's file system. You can use this path in your code for various purposes, such as saving files in the same directory, referencing files in that location, or performing other file-related operations.
VBA Example:
Sub Open_Hyperlink()
'Used to open link with default browser in a new tab
ThisWorkbook.FollowHyperlink Address:="https://xlblueprint.com", NewWindow:=True
End Sub
Syntax
FollowHyperlink (Address, SubAddress, NewWindow, AddHistory, ExtraInfo, Method, HeaderInfo)
Microsoft Documentation
Note: If you want to open a link in a particular browser you can use the "Shell" to do so. You need to make sure the the Path is correct (leads to the webpage exe on the users computer)
'Open link with Firefox
Shell ("C:\Program Files\Mozilla Firefox\firefox.exe" & " " & "https://xlblueprint.com")
'Open link with Edge
Shell ("C:\Program Files (x86)\Microsoft\Edge\Application\msedge.exe" & " " & "https://xlblueprint.com")
'Open link with Brave
Shell ("C:\Program Files\BraveSoftware\Brave-Browser\Application\brave.exe" & " " & "https://xlblueprint.com")
'Open link with Chrome
Shell ("C:\Program Files\Google\Chrome\Application\chrome.exe" & " " & "https://xlblueprint.com")
note - create macro to find folders on users computer