Microsoft KB Archive/207650

= ACC2000: RunApp Macro Action Does Not Open MS Money Properly =

Article ID: 207650

Article Last Modified on 1/26/2005

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q207650



Moderate: Requires basic macro, coding, and interoperability skills.



SYMPTOMS
When you use the RunApp macro action to open Microsoft Money version 4.0 or 5.0, the program does not open properly. The behavior varies depending on the version of Microsoft Money that you are using.

In Microsoft Money 4.0
The Microsoft Money splash screen appears on the screen, but you receive the following error message:

Not enough memory is available. If you have several applications open at the same time, you might need to close one of them before you start Money.

This behavior occurs even if Microsoft Access is the only application open at the time that you run your macro. When you click OK in the error dialog box, Microsoft Money quits.

In Microsoft Money 5.0
The Microsoft Money splash screen appears and you are prompted for a password if you have one, but the Microsoft Money program window does not open, and the program button does not appear on the taskbar. However, if you try to open Microsoft Money, you receive the following message:

Microsoft Money is already running.

If you are using Microsoft Windows NT and you start the Windows Task Manager, you see MSMONEY.EXE listed as a running process.



RESOLUTION
If you are using Microsoft Money 4.0 or 5.0, you can use the Shell function in a Visual Basic for Applications procedure in place of the RunApp macro action to open Microsoft Money. To do so, follow these steps:  In the Database Window, click Modules under Objects, and then click New. In the Visual Basic Editor, on the Insert menu, click Procedure. Type RunMoney in the Name box, select Function under Type, and then click OK.  Type the following line of code in the created function: Shell "C:\Program Files\Microsoft Money\msmoney.exe" NOTE: The path to msmoney.exe on your computer may be different.  Save the module as ProgramFunctions.  Create the following new macro that uses the RunCode command, and save it as RunAppTest: <pre class="fixed_text">  RunAppTest Actions RunCode Function Name: RunMoney </li> Run the macro.</li></ol>

<div class="status_section">

STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

<div class="moreinformation_section">

Steps to Reproduce Problem
<ol> Open the sample database Northwind.</li>  Create the following new macro that uses the RunApp command, and save it as RunAppTest: <pre class="fixed_text">  RunAppTest Actions -  RunApp Command Line: C:\Program Files\Microsoft Money\msmoney.exe </li> Run the macro.

Note that you see the behavior described in the "Symptoms" section.</li></ol>

The behavior described in this article applies only to Microsoft Money version 4.0 or 5.0. If you try to use the RunApp action to open Microsoft Money 98, you receive the following message:

Microsoft Access can't invoke the application using the RunApp action.

The path to the application is invalid, or a component of the application is missing.

Check the path in Windows Explorer or File Manager.

However, if you try to use the Shell function described in the "Resolution" section of this article, you receive the following error message:

Run-time error '53':

File not found

<div class="references_section">