After solving the issue in the below thread (different error, so thought it should be new thread), the user is then receiving a new error message:
https://www.accessforums.net/showthread.php?t=64212
"The command or action 'OutputTo' isn't available now. 2046"
I suspect, due to the wording "outputTo" that it is referring to one of the lines of code like:
Code:
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12
(irrelevant portions of code removed for brevity)
Anyone know how to solve for this?