Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Shell
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Shell
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 Viktor Ygdorff wrote: 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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Shell
Hello! Sorry I meant the Bloomberg program. Thanks anyway.
"Andrew Taylor" skrev: 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 Viktor Ygdorff wrote: 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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Shell
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. -- Regards, Tom Ogilvy "Viktor Ygdorff" wrote: Hello! Sorry I meant the Bloomberg program. Thanks anyway. "Andrew Taylor" skrev: 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 Viktor Ygdorff wrote: 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? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Shell
This will not help as you have to login to the Bloomberg as well as simply
running the executable. -- www.alignment-systems.com "Tom Ogilvy" wrote: 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. -- Regards, Tom Ogilvy "Viktor Ygdorff" wrote: Hello! Sorry I meant the Bloomberg program. Thanks anyway. "Andrew Taylor" skrev: 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 Viktor Ygdorff wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shell ? | Excel Programming | |||
Shell & VBA | Excel Programming | |||
Shell | Excel Programming | |||
VBE COM Add-in Shell | Excel Programming | |||
Shell | Excel Programming |