Macro needed

[Benaway]

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 [highlight #FCE94F]NEW instance[/highlight] and at the same time will close and save workbook1.

 

[DjangMan]

What have you tried so far?

 

[SkipVought]

Hi,

In addition to the information asked for by DjangMan, please explain the [highlight #FCE94F]need[/highlight] for "a [highlight #FCE94F]NEW instance[/highlight]" of the Excel Application for workbook2, rather than the current instance of the Excel application with workbook1.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]