What's week1?

Maybe:

..parent.saveas filename:="c:\" & week1 &".xls
or
..parent.saveas filename:="c:\week1.xls"

What happened to using the name of the worksheet?


"Brian Thompson via OfficeKB.com" wrote:

not knowledgable enough with command line
got error with below
.parent.saveas filename:=c:/&.week1&".xls

rian Thompson wrote:
Hi
I am not sure, hope this explains
Workbook saved as Yard Summary
52 shhets in workbook, one for each week
Weekly i update one sheet and copy sheet, then paste special to new sheet ,
format, and "save as "new sheet as per the tab name
Incidentaly, I do have the cell A1 in each sheet =Cell("filename",A1) giving
the tab name in the sheet
Q. Is macro for the "save as" section possible?

regards

with activesheet
.parent.saveas filename:="C:\" & .name & ".xls", ...rest of options
[quoted text clipped - 21 lines]

regards

--
Message posted via http://www.officekb.com

--

Dave Peterson