Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open Outlook
Hi All,
I just want to ensure that Outlook is open before I do other things. I tried a .bat file with the command below, but no luck. Can anyone tell me why, or offer a VBA script to do the same? TIA! CALL C:\Program Files\Microsoft Office\OFFICE11\Outlook.exe |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open Outlook
Jeff
I think this will work Dim olApp As Outlook.Application On Error Resume Next Set olApp = GetObject(, "Outlook.Application") If Err.Number = 429 Then Set olApp = CreateObject("Outlook.Application") End If On Error GoTo 0 olApp.Visible = True -- Dick Kusleika Excel MVP Daily Dose of Excel www.dicks-blog.com JEFF wrote: Hi All, I just want to ensure that Outlook is open before I do other things. I tried a .bat file with the command below, but no luck. Can anyone tell me why, or offer a VBA script to do the same? TIA! CALL C:\Program Files\Microsoft Office\OFFICE11\Outlook.exe |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open Outlook
You can use Shell Jeff
Shell "C:\Program Files\Microsoft Office\OFFICE11\Outlook.exe" -- Regards Ron de Bruin http://www.rondebruin.nl "JEFF" wrote in message ... Hi All, I just want to ensure that Outlook is open before I do other things. I tried a .bat file with the command below, but no luck. Can anyone tell me why, or offer a VBA script to do the same? TIA! CALL C:\Program Files\Microsoft Office\OFFICE11\Outlook.exe |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open Outlook
Jeff,
You can have multiple instances of Outlook, so why not just create your own, non-visible instance and quit it when finished. Dim MyOutlook as Outlook.Application Set MyOutlook=New Outlook.Application NickHK "JEFF" wrote in message ... Hi All, I just want to ensure that Outlook is open before I do other things. I tried a .bat file with the command below, but no luck. Can anyone tell me why, or offer a VBA script to do the same? TIA! CALL C:\Program Files\Microsoft Office\OFFICE11\Outlook.exe |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to open Excel in different windows AND open from Outlook? | Setting up and Configuration of Excel | |||
excel open in outlook if outlook is running | Excel Discussion (Misc queries) | |||
Open Outlook with generic message | Excel Discussion (Misc queries) | |||
open outlook contact | Excel Discussion (Misc queries) | |||
Open MS Office Outlook | Excel Programming |