Richard,

Use the Application.Ontime method to schedule an second macro (one that does
the worksheet export) a short time after the workbook opens, to give the
data pull time to finish.

HTH,
Bernie
MS Excel MVP


"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