I have been running the following code twice a day for 1-2 weeks, suddenly it does not work. The destination sheet is not updated. While playing around and stepping through this, I tried another version which actually opens the Xcel application. All of a sudden I got a message to the effect "file already open, do you want a new version". I left Access open, transfered to Xcel and saw exactly the data that was supposed to be there. Then I closed Xcel, closed Access, and went to open the Xcel file on the server from scratch. It was blank - no data.

It's behaving as if the data is transfered but Xcel is not being saved.
What is happening and why is it different than last week?

Sub Send2Xcel()
'transfer stuff to specific Xcel worksheets
'the trick is to use range names in Xcel *exactly* same as query names to receive the data
Dim fileNpath As String

On Error GoTo Errors2Xcel

fileNpath = "\\Uscu-fs3\sox symantec\SOX Core Team Folder\Dashboards\FY07\"
fileNpath = fileNpath & "Metrics2_failed_TRs"

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "q3IS_TR_FIL", fileNpath, True
Exit Sub

Debug.Print Err.Number & "::" & Err.Description
End Sub