Thread: Active Workbook
View Single Post
  #6  
Old June 1st, 2010, 09:20 PM posted to microsoft.public.excel.misc
Kim
external usenet poster
 
Posts: 820
Default Active Workbook

I have another kink in this.
I am working in 2007, but original file was .xls and saved as .xls. With
the SaveAs I originally had FileFormat:=xlNormal, but this returned "argument
not found".


"Dave Peterson" wrote:

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
.