Macro to Refresh Data & Print

[cruwyser]

Hi all,

I have a small problem.....I am currently using Excel to import some external data from an Oracle database. As this is a report, the process needs to be automated, hence I need a macro.

I need to generate a macro which refreshes the data in the worksheet, then prints the report out and closes the workbook/applciation.

I have generated the macro, but the macro prints the report before the data has refreshed.

Tried various versions of pause/wait/sleep, but still cant get it to work?

Any ideas would be of great help!

Many thanks in advance.

[JakeyC]

By setting the BackgroundQuery property to False the code (and Excel)
will wait for the refresh to complete.

Range("Whatever").QueryTable.Refresh BackgroundQuery:=False should work