Renaming a workbook without saving

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Matt - 22 May 2006 10:27 GMT

Hello Everyone

I'm trying to rename a workbook, so that I can select it later on in the
macro as I move between different workbooks. I do not want to save it though
as I do not want to keep the file and it will also take up time

I've tried a simple

ActiveWorkbook.Name = "Analysis Code Data"

But this won't work as I am trying to 'assign a read-only property'

Thanks in advance for any help

Reply to this Message

funkymonkUK - 22 May 2006 10:32 GMT

could you explain your process abit more in detail.

do you have like a master workbook which open another workbook then you
want to shift from one to the other?

Signature

funkymonkUK

Reply to this Message

Norman Jones - 22 May 2006 10:47 GMT

Hi Matt,

A workbook can only be named as part of a save process.

Try, instead setting thw workbook to an object variable which you can
subsequently reference in your procedure, e.g.:

Dim WB As Workbook

Set WB = ActiveWorkbook

---
Regards,
Norman

> Hello Everyone
>
[quoted text clipped - 10 lines]
>
> Thanks in advance for any help

Reply to this Message

Matt - 22 May 2006 11:07 GMT

Thanks Norman

That does exactly what I was after

Cheers

Matt

> Hi Matt,
>
[quoted text clipped - 25 lines]
> >
> > Thanks in advance for any help

Reply to this Message