OutputTo Excel not working in MDE version

[mbentley]

I have an OutputTo command that works fine until I convert the database to and mde file, then I get Error 2046: The command or action 'OutputTo' isn't available now. Here's my code:

DoCmd.OutputTo acOutputQuery, strQuery, acFormatXLS, strSaveFileName

Any ideas why this would be happening?

 

[FLabrecque]

Have you tried docmd.transferspreadsheet?

I have no other lead or clue.

 

[mbentley]

That works.
Thanks.

Still curious why OutputTo doesn't work, if anyone knows.