and makes sure that in querytable properties you uncheck the 'enable
background refresh' option.

On Mar 1, 7:59*pm, Tony Sardina wrote:
In your refresh the data section of your code try putting in the following command .Refresh BackgroundQuery:=False
This worked in the code I was using where I had dependent code following it.



On Wednesday, August 19, 2009 3:48 AM arvid.raaendonotspam.gjertse wrote:
I have a application with several Microsoft Query ODBC extracts to Excel.
How to make the application wait until the extract is finished.
The application will start processing on the extracted data but must not go
on before the data is fully extracted.

I have also the same problem with running SQL-sommands from Microsoft query
inserting data into commands filling a DB2 table. Whenti konow when the query
is finished

--
Arvid R. G.
Submitted via EggHeadCafe
ASP.NET JSON Cookies and Excel
http://www.eggheadcafe.com/tutorials...350-8611-b...- Hide quoted text -

- Show quoted text -