Running access macro from excel

[excelmacro]

Is it possible to run and access macro using an excel macro?
This message was edited by excelmacro on 2002-04-25 08:22

 

[fdavidgolf]

this will start access then maybe you could run the macro. maybe this will start you.

ActivateMicrosoftApp Method


Activates a Microsoft application. If the application is already running, this method activates the running application. If the application isn't running, this method starts a new instance of the application.

Syntax

expression.ActivateMicrosoftApp(index)

expression Required. An expression that returns an Application object.

index Required Long. Specifies the Microsoft application to activate. Can be one of the following XlMSApplication constants: xlMicrosoftWord, xlMicrosoftPowerPoint, xlMicrosoftMail, xlMicrosoftAccess, xlMicrosoftFoxPro, xlMicrosoftProject, or xlMicrosoftSchedulePlus.