RunApp macro in access 2007

In access 2003 their is a RunApp macro to run applications from a macro. In access 2007 (at least my copy) it does not show up. Is it my copy or has it been taken out of this version.

I just looked and it would appear that one has been removed.

However, with a little instruction you can use VBA to do what you need.

Have you used any?

You can use the Shell function in VBA to open up an EXE file.

Hi Mike,

Click the Show All Actions button in the Show/Hide group on the Macro Design Tools tab.

(It's a toggle button.)

By default, Access 2007 only displays "trusted" macro actions. Clicking this toggle button shows you all 70+ macro actions. In order to run those particular "untrusted" macro actions, you'll of course have to enable the content and/or place the database in a trusted location.

--------------------
Jeff Conrad - Access Junkie - MVP Alumni
SDET - XAS Services - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------