Thread: Active Workbook
View Single Post
  #5  
Old June 1st, 2010, 07:59 PM posted to microsoft.public.excel.misc
Harald Staff[_2_]
external usenet poster
 
Posts: 198
Default Active Workbook

SaveCopyAs

HTH. Best wishes Harald

"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