Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open another Office app from Excel
Hello all,
Can anyone provide some sample code to open an Office application such as Outlook from Excel using a macro? Thanks, Rohit Thomas |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open another Office app from Excel
Thanks Vasant. Appreciate the help...
-----Original Message----- Hi Rohit: Look at the ActivateMicrosoftApp method; e.g.: Application.ActivateMicrosoftApp xlMicrosoftMail will activate or open Outlook. Regards, Vasant. "Rohit Thomas" wrote in message ... Hello all, Can anyone provide some sample code to open an Office application such as Outlook from Excel using a macro? Thanks, Rohit Thomas . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open another Office app from Excel
My next question which i should have asked in the original
post. How do I do the opposite. Quit an Office app like Outlook from Excel using a macro? Thanks, Rohit -----Original Message----- Hi Rohit: Look at the ActivateMicrosoftApp method; e.g.: Application.ActivateMicrosoftApp xlMicrosoftMail will activate or open Outlook. Regards, Vasant. "Rohit Thomas" wrote in message ... Hello all, Can anyone provide some sample code to open an Office application such as Outlook from Excel using a macro? Thanks, Rohit Thomas . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open another Office app from Excel
Hi Rihit:
Something like: Sub CloseOutlook() Dim OL As Object On Error Resume Next Set OL = GetObject(, "Outlook.Application") On Error GoTo 0 If OL Is Nothing Then MsgBox "Outlook is not running!" Else OL.Quit End If End Sub Regards, Vasant. "Rohit Thomas" wrote in message ... My next question which i should have asked in the original post. How do I do the opposite. Quit an Office app like Outlook from Excel using a macro? Thanks, Rohit -----Original Message----- Hi Rohit: Look at the ActivateMicrosoftApp method; e.g.: Application.ActivateMicrosoftApp xlMicrosoftMail will activate or open Outlook. Regards, Vasant. "Rohit Thomas" wrote in message ... Hello all, Can anyone provide some sample code to open an Office application such as Outlook from Excel using a macro? Thanks, Rohit Thomas . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I open Open Office Calc with Excel | Excel Discussion (Misc queries) | |||
eula pops up every time i open an office program. office 2003 ins. | Excel Discussion (Misc queries) | |||
How can I open a Open Office Calc (ods) file in excel | Excel Discussion (Misc queries) | |||
Have XP Office '02, sent Excel ss '03 - can't open! | Excel Discussion (Misc queries) | |||
Unable to open Office 2007 files using Office 2002 XP | Excel Discussion (Misc queries) |