Shell

[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?

 

[Andrew Taylor]

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

 

[Guest]

Hello! Sorry I meant the Bloomberg program. Thanks anyway.

"Andrew Taylor" skrev:

 

[Guest]

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.