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
> >
> >
>
>
>