Hello all,

Can anyone provide some sample code to open an Office
application such as Outlook from Excel using a macro?

Thanks,
Rohit Thomas

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


.

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


.

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


.