Receiving an error when scheduling Macros from Windows Task schedu

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a macro that quits the application, it works fine if I click the run
command from access, but when I use the windows task scheduler to run this
macro I receive a warning, stating: If you're running a Visual basic module
that is using OLE or DDE, you may need to interrupt the module. Can any one
help me with this issue
 
Shun,

What are the actions in the macro? What is the command line you are
using for the scheduler?
 
In my macro the actions are:

SendObject (to send a snapshot of a report)
Quit (to quit the application)

my command line is : "C:\Documents and Settings\alic\Desktop\Shortcut to
Schedule Macros in AssemblyInstructionDatabase.MAM"
 
Shun,

Your scheduler command line should be in the equivalent of this syntax...
"C:\Program Files\Microsoft Office\...\Msaccess.exe"
"C:\PathToDB\YourDb.mdb" /x NameOfMacro

I recommend the name of the macro to not have any spaces in it.
 
Should the macro name be enclosed in quotes?



Steve Schapel said:
Shun,

Your scheduler command line should be in the equivalent of this syntax...
"C:\Program Files\Microsoft Office\...\Msaccess.exe"
"C:\PathToDB\YourDb.mdb" /x NameOfMacro

I recommend the name of the macro to not have any spaces in it.
Click to expand...
 
Back
Top