Run external program from Outlook VBA macro

[Marvin Buzz]

I would like to run an external program from within a macro in Outlook VBA.
I need some sample code to get to the program.

Also, is there a way to have an Outlook macro run each time Outlook is
started?

Thanks.

 

[Michael Bauer [MVP - Outlook]]

1) Depending on the program, the CreateObject function might work for you.

2) See the Application_Startup event.

--
Best regards
Michael Bauer - MVP Outlook

: Outlook Categories? Category Manager Is Your Tool
: VBOffice Reporter for Data Analysis & Reporting
: <http://www.vboffice.net/product.html?pub=6&lang=en>


Am Tue, 6 Oct 2009 16:06:01 -0700 schrieb Marvin Buzz:

 

[Marvin Buzz]

Could you provide a sample please?

1) Depending on the program, the CreateObject function might work for you.

2) See the Application_Startup event.

--
Best regards
Michael Bauer - MVP Outlook

: Outlook Categories? Category Manager Is Your Tool
: VBOffice Reporter for Data Analysis & Reporting
: <http://www.vboffice.net/product.html?pub=6&lang=en>


Am Tue, 6 Oct 2009 16:06:01 -0700 schrieb Marvin Buzz:

 

[Michael Bauer [MVP - Outlook]]

For the Application_Startup there's a sample in the VBA help file.

What program do you try to automate, does it offer an object model (like
Outlook, Word etc.) that you can use?

--
Best regards
Michael Bauer - MVP Outlook

: Outlook Categories? Category Manager Is Your Tool
: VBOffice Reporter for Data Analysis & Reporting
: <http://www.vboffice.net/product.html?pub=6&lang=en>


Am Wed, 7 Oct 2009 06:18:02 -0700 schrieb Marvin Buzz:

 

[Marvin Buzz]

It is a self-written program written in Visual Basic.

 

[Michael Bauer [MVP - Outlook]]

In VB6 you can have either a COM application with a creatable, public object
(the root object often is called Application), or a standard exe, which can
be launched with the Shell function.

--
Best regards
Michael Bauer - MVP Outlook

: Outlook Categories? Category Manager Is Your Tool
: VBOffice Reporter for Data Analysis & Reporting
: <http://www.vboffice.net/product.html?pub=6&lang=en>


Am Wed, 7 Oct 2009 11:48:21 -0700 schrieb Marvin Buzz: