schedule a macro

  • Thread starter Thread starter santana
  • Start date Start date
S

santana

I am trying to set up a macro that runs on a scheduled time. This is what I
entered:
"C:\Documents and Settings\All Users\Start Menu\Programs\Microsoft
Office\Microsoft Office Access 2007.lnk" “E:\ db1.mdb “ / x Macro1
When the schedule task runs I receive the following error message:
"The command line used to start Microsoft Office Access contains an options
that Microsoft Office doesn’t’ recognize". Any idea on how to fix?
 
Santana,

Your command line needs to point to the Microsoft Access program.
"C:\Documents and Settings\All Users\Start Menu\Programs\Microsoft
Office\Microsoft Office Access 2007.lnk" points to a shortcut of some sort.
Instead, it should be something like this:
"C:\Program Files\Microsoft Office\Office 12\Msaccess.exe"

Also, there appears to the two incorrect spaces in “E:\ db1.mdb “ which
should be “E:\db1.mdb“

Also, the quotes around “E:\ db1.mdb “ appear to be "smart quotes", as if
you have copy/pasted this from somewhere like a word processing or web
interface. You should re-type, using text quotes "".

Also, there is an incorrect space in:
/ x Macro1
It should be:
/x Macro1
 
Back
Top