Can I write a macro in Excel that runs a macro from Access DB

T

Timmy

I need to create a macro in Excel that would run run a macro from MS Access
database
 
R

Rob Oldfield

You can just start Access with the /x switch to specify a macro to run.
Something like..

<path>\msaccess.exe <path>\whatever.mdb /x MacroToRun

You should be able to run that from Excel via a Shell command.
 
T

Timmy

Hi Rob
What's a Shell command?
Rob Oldfield said:
You can just start Access with the /x switch to specify a macro to run.
Something like..

<path>\msaccess.exe <path>\whatever.mdb /x MacroToRun

You should be able to run that from Excel via a Shell command.
 
V

VernonHowell via AccessMonster.com

Timmy said:
Hi Rob
What's a Shell command?
You can just start Access with the /x switch to specify a macro to run.
Something like..
[quoted text clipped - 6 lines]

Right,

Good point Timmy.
What is a Shell command....I mean we are not gurus....in fact we hardly know
anything...this crap sucks.
 
T

Timmy

You're right this crap does suck

VernonHowell via AccessMonster.com said:
Timmy said:
Hi Rob
What's a Shell command?
You can just start Access with the /x switch to specify a macro to run.
Something like..
[quoted text clipped - 6 lines]
Access
database

Right,

Good point Timmy.
What is a Shell command....I mean we are not gurus....in fact we hardly know
anything...this crap sucks.
 
Top