I need a way for a macro to open a new copy of a current Excel workbbok, do some adjustment to it and save it without closing the current active workbook. The application that I am using uses Excel 2003 as it's front end, but if I open a new copy of the workbook, it automatically closes the current one and I lose all the data. The new copy is NOT automatically part of the outer application's file system, which normally is how the data is saved to the database behind it.

So - is there a way to open a new copy, and keep the current copy open as well? Thanks in advance!

Paul.