Scheduled task and a macro

B

BFB

I would like to to create a Scheduled Task and have it
run a macro in my access database. The database is at ...

S:\Program Database\Tremont Databases and the macro is
called "Auto Send"

Any thoughts?
 
J

Jim/Chris

Use Windows Task Scheduler, or one of the many third-party
scheduling programs available today, to run the macro
using a command line like this...

"C:\PathToAccess\Msaccess.exe" "C:\PathToDB\MyDB.mdb" /x
macroname

Jim
 
D

Danimagus

What about with Excel? /x doesn't work for an .xls, which is what I'
trying to correct
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto populate value from one task to another in MS PROJECT 0
Someone knows how to add hyperlinks to hours to schedule an appointment? 0
No Current Record Error, Scheduled Task 4
Need Help with Macro Security 1
Can we use outlook calendar as an universal place post work schedules for all the users? 0
Every New Tasks Wants to Start in the Future 1
Find and replace macro for Special ^p - MS Word 0
How to set a rotating shift schedule for 4 crews with repeat occurrence? -SOLVED 1

Top