How to run one macro after another macro finishes

**alrichar** · 08-28-2012, 09:06 AM

I have created a form in excel/vba/sql that refreshes several queries and then copies and paste values that information into another spreadsheet. The problem is that the macro will copy and past special the data before the refresh macro finishes. Is there a way to execute one macro after the previous macro finishes? I added an this code [Application.Wait Now + TimeValue("00:02:00") ] to the macro but it is not working the way I had hoped. It seems like this just stops all of the macros, not just one macro.

Here is the code for the two macros:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

**arlu1201** · 08-28-2012, 09:16 AM

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature.

**alrichar** · 08-29-2012, 08:44 AM

Thank you for bringing that to my attention.

**JosephP** · 08-29-2012, 08:45 AM

make sure that the queries are set to not refresh in the background and then you can just call one macro after the other

**alrichar** · 08-29-2012, 09:47 AM

That seems to solve this issue. I used the following code. Thanks for the help!

Please Login or Register  to view this content.

I also removed this code from the first macro.

Please Login or Register  to view this content.

**Cutter** · 08-29-2012, 01:02 PM

@ alrichar

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.