Thread: Active Workbook
View Single Post
  #4  
Old June 1st, 2010, 07:45 PM posted to microsoft.public.excel.misc
Gary Brown[_6_]
external usenet poster
 
Posts: 61
Default Active Workbook

You need to re-open the original.
Prior to save as, put the current name in a variable.
After the save as, open the original using that variable.

Something like...

strOriginalName = ActiveWorkbook.FullName
....save as code
Workbooks.Open Filename:= strOriginalName

--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



"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