Shell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

VBA has a Shell command that can open certain programs like this:

RetVal = Shell("C:\WINDOWS\CALC.EXE", 1) ' Run Calculator

Is it possible to open Bloomberg using this command?
 
If you mean you want to open the Bloomberg website, try this:
(lines split to avpoid wrapping)

Private 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

Sub OpenBloomberg()
Dim RetVal As Long
RetVal = ShellExecute(0&, "OPEN", _
"http://www.bloomberg.com", "", 0&, 1)
End Sub
 
if you could go into the command prompt and type a command that will start it
or perhaps type the command in the run box under windows start, then yes, you
should be able to execute that command with SHELL.
 
Back
Top