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

[Guest]

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

 

[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.

 

[Guest]

Hi Rob
What's a Shell command?

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.

 

[VernonHowell via AccessMonster.com]

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

Right,

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

 

[Guest]

You're right this crap does suck

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.

 

[Rob Oldfield]

It's a standard Excel VBA command.

Hi Rob
What's a Shell command?