Changing workbook name in macro

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dutch76 - 26 Jan 2006 08:40 GMT

I want to change (in a macro) a workbook name before saving. Fo
instance: the original file is opened as "test.xls", an InputBox ask
for the extension (here: _abc) and on saving the name should b
"test_abc.xls". I don't want the original file to be overwritten. Ho
can I achieve this

--
Dutch7

Reply to this Message

Bob Phillips - 26 Jan 2006 09:52 GMT

With Activeworkbook
.saveas filename:= left(.name,len(.name)-4) & ib_value & ".xls"
End With

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

> I want to change (in a macro) a workbook name before saving. For
> instance: the original file is opened as "test.xls", an InputBox asks
[quoted text clipped - 7 lines]
> Dutch76's Profile: http://www.hightechtalks.com/m829
> View this thread: http://www.hightechtalks.com/t2343497

Reply to this Message