Receiving an error when scheduling Macros from Windows Task schedu

[shun]

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

 

[Steve Schapel]

Shun,

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

 

[shun]

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"

 

[Steve Schapel]

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.