Run external program from Outlook VBA macro

  • Thread starter Thread starter Marvin Buzz
  • Start date Start date
M

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.
 
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:
 
Could you provide a sample please?

Michael Bauer said:
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:
Click to expand...
 
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:
 
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:
 
Back
Top