VBA Performance

[Fherrera]

Hi, i currently am working on some excel code that connects to a database and returns some values. Problem is it is a huge database (Access) and it takes some time. If I run the queries from within Access I can still do some stuff in the background (highly reduced in speed, but still somewhat tolerable). When I run the queries from Excel to return the data to excel, the whole machine locks up. I literally can't do anything until the code is finished executing.

Is there an option to make the VBA not take so much priority, so I can atleast browse the web in the background, err, Do other work in the background

Thanks

Frank

 

[PHV]

Yes, a QueryTable has a BackgroundQuery boolean property and the Refresh method may be launched in Background too.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Fherrera]

I'm using recordsets and the openrecordset() function..

Are these two things similar?

 

[PHV]

No. A querytable is created by the Get external data menu option.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[sdraper]

Since Access works better could you do it in access and export the results to excel either manually or programmatically?

Sam