Saving worksheet as CSV after pulling data from an external data source

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

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" <richard@not.my.address.com> wrote in message
news:el2SIwmGFHA.2976@TK2MSFTNGP15.phx.gbl...
> 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
>
>

Richard,

Try this. Turn off Refresh on Open. In your code, do the refresh,
something like:

Range(OracleDataRange).QueryTable.Refresh BackgroundQuery:=False

Then save do the Save as CSV.

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

"Richard Edwards" <richard@not.my.address.com> wrote in message
news:el2SIwmGFHA.2976@TK2MSFTNGP15.phx.gbl...
> 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
>
>

In the definition of your query table, don't allow it to do a background
refresh.

--
Regards,
Tom Ogilvy

"Richard Edwards" <richard@not.my.address.com> wrote in message
news:el2SIwmGFHA.2976@TK2MSFTNGP15.phx.gbl...
> 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
>
>

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" <twogilvy@msn.com> wrote in message
news:e7gtB4nGFHA.2412@TK2MSFTNGP14.phx.gbl...
> In the definition of your query table, don't allow it to do a background
> refresh.
>
> --
> Regards,
> Tom Ogilvy
>
> "Richard Edwards" <richard@not.my.address.com> wrote in message
> news:el2SIwmGFHA.2976@TK2MSFTNGP15.phx.gbl...
>> 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
>>
>>
>
>