Macro needed Macro needed Benaway (TechnicalUser) (OP) 13 Jul 17 15:46 I have 2 workbooks. I need a macro that when activated in workbook1, it will take you to workbook2 with its own path in a NEW instance and at the same time will close and save workbook1. RE: Macro needed DjangMan (Programmer) 13 Jul 17 17:33 What have you tried so far? RE: Macro needed SkipVought (Programmer) 13 Jul 17 18:49 Hi, In addition to the information asked for by DjangMan, please explain the need for "a NEW instance" of the Excel Application for workbook2, rather than the current instance of the Excel application with workbook1. Skip, Just traded in my OLD subtlety... for a NUance!