Look at SaveCopyAs in VBA's help.

Kim wrote:

Using Excel 2007, I have a macro where I use a workbook, then save as a new
named workbook. I want to keep the original workbook open. What code
language will accomplish this? Even manually, I do not see how to save as a
copy and keep original file open.

Thank you

--

Dave Peterson