Hi all,
Not sure if this has been covered before and if so I apologise in advance (and can somebody please point me to the relevant thread). I’m new to VB so I’m learning on the run; but have managed to work out how to do most things so far; except this one…
I have a number of workbooks that I copy either single or multiple sheets from to save and send; all using a date variable as part of the new workbook title.
What I’m looking to do is to be able to save the new workbook and then move between it and the original master copy within the same Macro as I do the copy and save in. I’ve had a bit of a trawl of the web but can’t seem to find a solution to be able to activate original document (which I can do) then reactivate the “new” workbook.
Because I’m sending the “new” workbook directly through Outlook I need to finish in that one for that part of the Macro to work (as far as I’m aware). What I want to do is to incorporate a separate Macro that currently needs running separately in the master workbook; all as part of the same single click.

Any help would be appreciated; sorry if I’ve been a little vague or confusing with the explanation

Thanks,
Craig...