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



"Brian Thompson via OfficeKB.com" wrote:

Hi
In cell A1 i have =cell"filename"A1 giving me the
I want to run macro that will save new file with data in A1

Example. tab named wc0701. new file saved as wc0701

Any idea's

regards

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

--

Dave Peterson