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