View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Matt Matt is offline
external usenet poster
 
Posts: 516
Default Renaming a workbook without saving

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