Runtime Error 2046

[Jagerdawg]

I set a macro using the 'OutputTo' command to export tables in an Excel format.

The macro works when I lauch it manually, however when I use the Windows scheduler I receive the following error:

"Run-time Error 2046. The command or action OutputTo isnt available now"


I figure there is some permission setting I am missing. Any help would be greatly appreciated.

Thanks in advance.

 

[ChrisUK]

Take a look at this article, not the same problem but very close and I'll bet linked!

http://support.microsoft.com/defaul...port/kb/articles/q244/6/95.asp&NoWebContent=1

Incidently all I did to get this was type "Access Run time 2446" into google

ChrisUK