Hi Dave
Sorry not understand
The workbook is saved as "name"
each week one tab will be formatted and then saved as the "tab name" of in my
case as cell A1 owing to the formula in A1
I,m not fully ofay with VBA, however, can edit the existing macro with the
correct lines

Hope this makes sence

brian

Dave Peterson wrote:
You could just drop the formula in A1 and use the worksheet name itself.

with activesheet
.parent.saveas filename:="C:\" & .name & ".xls", ...rest of options
end with

Hi
In cell A1 i have =cell"filename"A1 giving me the
[quoted text clipped - 5 lines]

regards


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200601/1