Isaac
Lifelong Learner
- Local time
- Today, 07:03
- Joined
- Mar 14, 2017
- Messages
- 8,777
I have had trouble with OutputTo vs. TransferSpreadsheet when working in accdr, accde, or otherwise navigation pane hidden - unfortunately I cant' remember which I had more trouble with at the moment, but the trouble was such that you had to have a line of code opening the source object [table or query] prior to running the export line of code. Which was very silly. I can't remember which one it was, outputto or transferspreadsheet, and not sure if it applies to your problem at hand, but one or the other of them barfs when trying to export the results of a non-open object in certain cases.