Tom,

I had to do a query refresh in code a while back, in Workbook_open, I'm
pretty sure. It was Excel 2000. The Refresh On Open didn't happen until
the Workbook_Open had run, so I did it in code.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Tom Ogilvy" wrote in message
...
In the definition of your query table, don't allow it to do a background
refresh.

--
Regards,
Tom Ogilvy

"Richard Edwards" wrote in message
...
All,

I am trying to load an Excel workbook. Have that workbook update from an
external datasource (oracle). Then save as a CSV.

I have tried putting code in the "on workbook open" but code is run
before
the data is refreshed. The data is set to auto-refresh on startup

Does anyone have any suggestions?

Thank you.

Richard