Renaming a workbook without saving

[Matt]

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

[funkymonkUK]

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?

[Norman Jones]

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" <Matt@discussions.microsoft.com> wrote in message
news:35358124-7F47-417C-AA07-E15A73DCFA15@microsoft.com...
> 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
>
>

[Matt]

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" <Matt@discussions.microsoft.com> wrote in message
> news:35358124-7F47-417C-AA07-E15A73DCFA15@microsoft.com...
> > 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
> >
> >
>
>
>