RunTime 2501 - The OutputTo Action was canceled ???

R

Richard Albrecht

Hi,

I'm working in an Access 2000 program where I'm looping through and creating
a dynamic query and outputing it to an Excel Spread sheet. If I step
through the code it works fine, however if I run it I get the above error on
this line:

DoCmd.OutputTo acOutputQuery, "qryRicReportToExcell", acFormatXLS,
lsSaveFileName, False

Access drives me nuts sometimes. I have tried puting a DoEvents before it
to no avail.

Anybody got any idea???

Rich
 
Top