Pausing a macro to wait for the results from the query

[ldevrries]

My EXCEL macro contains some queries that retrieve data from an ORACLE database and then do processing of that data. With debugging it is apparent that the macro tries to do the post-query processing of data before the data has actually been returned.

Is there a way not requiring human intervention to make the macro wait for the data? It works just fine if I add a breakpoint in the macro just after the query, but would prefer not having the break.

Thanks!

[JR@SGC]

Hi,

Theres no 'official' way but there are as usual, clever workarounds.

see the below for infomation as some will be quite complex to explain here.

http://support.microsoft.com/kb/212711

except this one

http://www.pcreview.co.uk/forums/thread-1628277.php

a few more

http://www.hummingbird.com/hostexplo...028.html?cks=y

http://p2p.wrox.com/topic.asp?TOPIC_ID=25435

I'm sure there is one here to suit your needs