You might use the "ShellExecute" command. It is not immediately
available in VBA. You need to use Windows API to set up these calls.
"ShellExecute opens a file with its default program.
There is an example of this in one of my publicly available macros
"CopyCustomInfo". I use ShellExecute to open the link to my website
from the user interface.
'
'put this in the general declarations section of your macro
'
'ShellExecute API
Public Declare Function ShellExecute Lib "shell32.dll" Alias
"ShellExecuteA" (ByVal hwnd As Long,
_
ByVal lpOperation As String, ByVal lpFile As String, ByVal
lpParameters As String, _
ByVal lpDirectory As String, ByVal nShowCmd As Long) As Long
'
'example of a Sub using "ShellExecute"
'
Public Sub OpenEsoxWeb()
ShellExecute 0, vbNullString, "
formatting link
",vbNullString, "C:\", 1
End Sub