scheduled task to run a macro

[rewdee]

I would like to create a schedule task that will run a macro. I'm having trouble with the syntax. I've tried

C:\somepath\msaccess.exe c:\somepath\someMDB.mdb /cmd /x SomeMacro.macro

Does anyone know the exact line to type in.

Thanks,
Rewdee

 

[KyleS]

RewDee,
So you're trying to create a batch file to automatically open a db and run a marco, right?

The line is right except for the "/cmd " Take that out and it should work IF you're running WinNT 4.0 I don't know the syntax for Win 2000

But check out this website:

http://www.robvanderwoude.com/index.html

Hope this helps
Kyle :

 

[cmmrfrds]

Here is one of my bat files that I run from Win98. I interrupt the cmd in the program to decide what processing to do i.e. run macro etc..

rem
Echo "Running Access 850 processing ...................."
cd "C:\Program Files\Microsoft Office\Office"
"Msaccess.exe" "C:\edi\850in\EDI850IN.mdb" /cmd "850IN"