Using a workbook name

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chris Rees - 24 Sep 2007 12:46 GMT

Is there anyway to use a workbook name in code without using
application.getsaveasfilename or getopenfilename? As I am trying to create
multiple workbooks from a master workbook and would prefer not to have to
save the workbook every time.

Reply to this Message

Bob Phillips - 24 Sep 2007 12:59 GMT

The workbook doesn't get a full name until it is saved.

You could always create a workbook object when you save it

Set oWB = Workbooks.Add

and use that object after that.

Signature

HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

> Is there anyway to use a workbook name in code without using
> application.getsaveasfilename or getopenfilename? As I am trying to create
> multiple workbooks from a master workbook and would prefer not to have to
> save the workbook every time.

Reply to this Message

JW - 24 Sep 2007 13:00 GMT

Just set the workbook name or workbook itself to a variable and use it
however you want.
Dim wbName As String
wbName=ActiveWorkbook.Name
or
Dim wb As Workbook
Set wb = AvtiveWorkbook

Reply to this Message