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?