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

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?


--
funkymonkUK
------------------------------------------------------------------------
funkymonkUK's Profile: http://www.excelforum.com/member.php...o&userid=18135
View this thread: http://www.excelforum.com/showthread...hreadid=544221

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



"Matt" wrote in message
...
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

Thanks Norman

That does exactly what I was after

Cheers

Matt


"Norman Jones" wrote:

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



"Matt" wrote in message
...
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