C
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.
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.
