Pause macro, select file, continue macro

**DamienC** · 07-18-2008, 06:33 AM

I am really not quite sure how best to word this, which I imagine is why I can't find it on a search engine.

I have two macros that I wish to run in sequence, but the two documents involved are not the same every day.

What I have put together so far (with a lot of help from RoyUK, whom I owe a few pints should I ever come across him) is I open the first document, and run macro 1. Macro 1 will do everything I want it to and will then take me to the correct folder to find the next file. I double click on the correct file to open it and then run macro 2 to do everything else.

I am wondering if it is possible to combine these two. That when I double click the file I want, it carries on with the macro rather than having to start a new one.

Is that realistic?

**mudraker** · 07-18-2008, 07:00 AM

It is possible

Withou seeing your macro code I can not advice the best way to do it

1 option is have a 3rd macro that calls the other 2

Sub MyMainMacro()
    Call Macro1
    Call Macro2
End Sub

Another option is to have macro1 call macro2 by placing a call command before the End Sub

A 3rd option is to combine the 2 macros codes into 1 macro

**royUK** · 07-18-2008, 07:02 AM

Add a macro to run the two macros

Sub doIt
Macro1'opens workbook
Macro2
End Sub

**DamienC** · 07-18-2008, 07:09 AM

Combining the two macros would be easy if it weren't for the fact I have to manually select and open the second workbook to continue.

I have already learned how to open a second spreadsheet automatically and the macro happily carrying on, but I have not yet worked with a macro that requires me to do something mid-macro.

**royUK** · 07-18-2008, 07:14 AM

Originally Posted by DamienC

Combining the two macros would be easy if it weren't for the fact I have to manually select and open the second workbook to continue.

I have already learned how to open a second spreadsheet automatically and the macro happily carrying on, but I have not yet worked with a macro that requires me to do something mid-macro.

If you do what we said and reeplace macro1 with the one that allows you to select the file, that macro will run to the end then the next macro will run.