Hello Everyone,
I am trying to create a macro in WorkbookA that will create WorkbookB, but if WorkbookB already exist, it will open WorkbookB, move control to WorkbookB and then close WorkbookA.
I have it to where it does all this, except I am not able to move the control to WorkbookB. I can jump to a macro in WorkbookB which I have setup to close WorkbookA, but then everything just stops. Does anyone know how I can start running a macro in WorkbookB after I close WorkbookA?
Thanks,
Jared
I am trying to create a macro in WorkbookA that will create WorkbookB, but if WorkbookB already exist, it will open WorkbookB, move control to WorkbookB and then close WorkbookA.
I have it to where it does all this, except I am not able to move the control to WorkbookB. I can jump to a macro in WorkbookB which I have setup to close WorkbookA, but then everything just stops. Does anyone know how I can start running a macro in WorkbookB after I close WorkbookA?
Thanks,
Jared