Memory resident macro with multiple web connection problem.

Hi

I am trying to get data from web connection after every 15 minutes. I have 14 web connections. I do 'refreshall' then it takes time to refresh all connection but macro continues execution of next line which is copying data to next sheet. (So data copied is old one). If I have 'save' command it says that this will terminate current process, probably refreshall, how to make macro wait till all connections are refreshed? Secondly, being memory resident macro, it remains invisible, hence I am not aware whether any macro is currently running or not. How can I track such a macro?

My code:

Please Login or Register  to view this content.

How to make this code more efficient and also avoid memory problems on running for long period. Is there a 'Clear all' for memory and at what position should it come so that it doesn't hamper 'memory resident' nature of the macro. I also want to save and stop execution of macro at or after 15.31 hours..

Thanks a lot.