Mircosoft Query

brettvba · Apr 14th, 2002, 10:17 PM

If the Data gets refreshed at the start of a macro for Excel does the macro wait for the data to be refreshed before continuing??

brettvba · Apr 15th, 2002, 02:11 PM

any Ideas?

Jack in the UK · Apr 16th, 2002, 01:32 PM

If Script ripps data via ODBC then YES will continue after the download is compleated and carry on with Macro..

BUt depends on exact VBA code of cause, this would be safest call off cause.. ie get the dat the work on it

brettvba · Apr 16th, 2002, 02:20 PM

Jack i'm only doing an
activeworkbook.refreshall
then I want to wait for it to finish before continuing the rest of the macro?

Jack in the UK · Apr 16th, 2002, 02:23 PM

refresh is more or less the save over / under ODBC if thats waht your using even crystal used MS ODBC drivers and Query, so should hang until compleated,

Can i ask where its going wrong?

brettvba · Apr 16th, 2002, 02:27 PM

I won't to make sure the data is refreshed first so that it's up to date but what is happinging

is that the keeps going on its way while the little earth at the bottom of the screen is still spinning and updating the information.

I just need some kind of code to pause for a specified amount of time without pausing the application(So it keeps updating)?

Jack in the UK · Apr 16th, 2002, 02:36 PM

The spinning globe world is as ODBC ripps data into excel so alls ok then when finished code will continue im sure so will be live current data.

all seems ok

Quote:

On 2002-04-16 13:27, brettvba wrote:
I won't to make sure the data is refreshed first so that it's up to date but what is happinging

is that the keeps going on its way while the little earth at the bottom of the screen is still spinning and updating the information.

I just need some kind of code to pause for a specified amount of time without pausing the application(So it keeps updating)?

brettvba · Apr 16th, 2002, 02:38 PM

yeah but I want it to finish before the rest of the code is run?

Jack in the UK · Apr 16th, 2002, 02:45 PM

exactly thats what my prev post says... ODBC will hold VBA script if ODBC is in code to rip data bfrom bespoke GLOBE hangs to allow data transfer intio excel, THEN code will continue/

brettvba · Apr 16th, 2002, 03:04 PM

I know what your saying jack thats what I thought it would do as well it is refreshing about 5 sheets some take up to a minute to refresh and I have watched the code executing while the tables are still refreshing I guess its back to the drawing board

Apr 16th, 2002, 01:32 PM	#3
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	If Script ripps data via ODBC then YES will continue after the download is compleated and carry on with Macro.. BUt depends on exact VBA code of cause, this would be safest call off cause.. ie get the dat the work on it __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Apr 16th, 2002, 02:23 PM	#5
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	refresh is more or less the save over / under ODBC if thats waht your using even crystal used MS ODBC drivers and Query, so should hang until compleated, Can i ask where its going wrong? __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Apr 16th, 2002, 02:45 PM	#9
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	exactly thats what my prev post says... ODBC will hold VBA script if ODBC is in code to rip data bfrom bespoke GLOBE hangs to allow data transfer intio excel, THEN code will continue/ __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 14th, 2002, 10:17 PM	#1
brettvba MrExcel MVP Join Date: Feb 2002 Location: Christchurch New Zealand Posts: 1,030	If the Data gets refreshed at the start of a macro for Excel does the macro wait for the data to be refreshed before continuing??

Apr 15th, 2002, 02:11 PM	#2
brettvba MrExcel MVP Join Date: Feb 2002 Location: Christchurch New Zealand Posts: 1,030	any Ideas?

Apr 16th, 2002, 02:20 PM	#4
brettvba MrExcel MVP Join Date: Feb 2002 Location: Christchurch New Zealand Posts: 1,030	Jack i'm only doing an activeworkbook.refreshall then I want to wait for it to finish before continuing the rest of the macro?

Apr 16th, 2002, 02:27 PM	#6
brettvba MrExcel MVP Join Date: Feb 2002 Location: Christchurch New Zealand Posts: 1,030	I won't to make sure the data is refreshed first so that it's up to date but what is happinging is that the keeps going on its way while the little earth at the bottom of the screen is still spinning and updating the information. I just need some kind of code to pause for a specified amount of time without pausing the application(So it keeps updating)?

Apr 16th, 2002, 02:38 PM	#8
brettvba MrExcel MVP Join Date: Feb 2002 Location: Christchurch New Zealand Posts: 1,030	yeah but I want it to finish before the rest of the code is run?

Apr 16th, 2002, 03:04 PM	#10
brettvba MrExcel MVP Join Date: Feb 2002 Location: Christchurch New Zealand Posts: 1,030	I know what your saying jack thats what I thought it would do as well it is refreshing about 5 sheets some take up to a minute to refresh and I have watched the code executing while the tables are still refreshing I guess its back to the drawing board