Unanswered: Transferspreadsheet fails, used to work?
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?
'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