Force Web Pull Macro to Run First

[keen2xl]

Hi

After WorkBook Automatically Re-Opens I Need Web Pull Set to Run First

That's all

This is a set up example Wb



(Please View, Wb and Click One Button To See How It Currently Runs and How It Should Run)


Appreciate thought through assistance of Course


Cheers Mike : )

[LJMetzger]

Hi Mike,

You can prove that Macro1 does indeed run before Macro2, by putting the following
statement at the top of the 1st Macro, which will invoke the debugger.

Please Login or Register  to view this content.

I know nothing about 'QueryTables', but the 'Wait' statements seemed to get in the
way of the 'QueryTables' command on my Windows Vista computer using Excel 2003.
I'm sure someone more 'QueryTables knowledgeable' than I, has an elegant solution
to your problem.

I was able to get the program to run quite robustly, by:
a. Eliminating all the 'Wait' statements after the call to 'QueryTables'.
b. Using a 'Worksheet_Change()' event on Sheet 'Tab Results' Cell 'A3'.
By trial and error I found that when the 'Target Address' for the cell
started with 'A3:F' that the 'QueryTables' update had completed.

Please Login or Register  to view this content.

[keen2xl]

Hi Metz

Thanks for Effort good work around cool, I just downloaded wb from here myself put in correct date (12th today) went to www.tab.co.nz got race code for a finished race, Clicked "Close Wb" when it opened i got run time error, put on manual button to updae Results and that worked fine soo ? Excel never ceases to perplex.

Any ways found out all i had to do was change ".Refresh BackgroundQuery:=True" to "False",which makes Wb query run at once,Otherwise its saying "Ok you other macros just carry on and complete ahead i'll update in the background".

Simple but took a week to find out.

Hope this helps someone also

Cheers my man

: ) Mike