Posted to microsoft.public.excel.programming

westg

external usenet poster

Posts: 16

pausing vba for refresh

I setup a query on an sql db. However I need the vba to pause while the query
refreshes and brings the data into Excel.

So far I have tried using
Application.Wait Now + TimeSerial(0, 0, 10)

However if a user is daft enough to run a query on huge amount of data, i am
screwed.

is there a way of pausing until the data has finished refreshing?

Many thanks, Andrew

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VBA macro pausing	[email protected]	Excel Worksheet Functions	2	February 23rd 09 01:19 PM
Pausing Macro	Patches	New Users to Excel	2	March 28th 07 03:00 AM
Is there a way of pausing a macro	Shazza	Excel Discussion (Misc queries)	2	March 12th 07 10:59 PM
Pausing a Macro	PaulW	Excel Discussion (Misc queries)	0	May 30th 06 02:05 PM
pausing a macro	Hasan Cansü[_2_]	Excel Programming	6	February 27th 04 06:40 PM

All times are GMT +1. The time now is 06:52 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us