Active Workbook
Correct, when you save-as, you are changing the name of active file, not
creating a copy. Perhaps this code?
Sub ReName()
xName = ActiveWorkbook.FullName
'Change this to something appropriate
ThisWorkbook.SaveAs "New Name"
'Opens original file
Workbooks.Open (xName)
'Close the copied file
ThisWorkbook.Close
End Sub
--
Best Regards,
Luke M
"Kim" wrote in message
...
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
|