Running access macro from excel

excelmacro · Apr 25th, 2002, 08:33 AM

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 · Apr 25th, 2002, 09:47 AM

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 25th, 2002, 08:33 AM	#1
excelmacro Board Regular Join Date: Apr 2002 Location: Alberta, Canada Posts: 50	Is it possible to run and access macro using an excel macro? [ This Message was edited by: excelmacro on 2002-04-25 08:22 ]

Apr 25th, 2002, 09:47 AM	#2
fdavidgolf New Member Join Date: Apr 2002 Posts: 26	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.