i'm actually opening two workbooks. the first

Set xlWB = .Workbooks.Open("C:\documents and settings\nfranciose\desktop\qryFORECAST", , True)
is a workbook that contains the macro i need, and the second

 DoCmd.OutputTo acOutputQuery, "qryFORECAST", acFormatXLSX, "C:\TEMP\Export.XLSx", True
is the query output that i need to apply the macro to. So there is still a workbook open after the "xlWB.Close (True)" runs.

---------- Post added at 02:01 PM ---------- Previous post was at 01:58 PM ----------

Are you saying that i can't manipulate the same workbook using "xlApp" and "ActiveWorkbook"?

---------- Post added at 02:03 PM ---------- Previous post was at 02:01 PM ----------

Because it works half the time...
Thanks, shg, for any suggestions!