G Guest Dec 2, 2005 #1 I need to create a macro in Excel that would run run a macro from MS Access database
R Rob Oldfield Dec 2, 2005 #2 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.
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.
G Guest Dec 2, 2005 #3 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. Click to expand...
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. Click to expand...
V VernonHowell via AccessMonster.com Dec 2, 2005 #4 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.. Click to expand... [quoted text clipped - 6 lines] Access Click to expand... Click to expand... Right, Good point Timmy. What is a Shell command....I mean we are not gurus....in fact we hardly know anything...this crap sucks.
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.. Click to expand... [quoted text clipped - 6 lines] Access Click to expand... Click to expand... Right, Good point Timmy. What is a Shell command....I mean we are not gurus....in fact we hardly know anything...this crap sucks.
G Guest Dec 2, 2005 #5 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.. Click to expand... [quoted text clipped - 6 lines] Access database Click to expand... Click to expand... Right, Good point Timmy. What is a Shell command....I mean we are not gurus....in fact we hardly know anything...this crap sucks. Click to expand...
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.. Click to expand... [quoted text clipped - 6 lines] Access database Click to expand... Click to expand... Right, Good point Timmy. What is a Shell command....I mean we are not gurus....in fact we hardly know anything...this crap sucks. Click to expand...
R Rob Oldfield Dec 3, 2005 #6 It's a standard Excel VBA command. Timmy said: Hi Rob What's a Shell command? Click to expand...
