If you use code to access it when opened, you get a handle to it.

Set newWB = ActiveWorkbook

then you can refer to myWB thereafter, active or not.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"pauluk " wrote in message
...
Hi,

How do you activate another workbook if you do not know the name of it.
I know this sounds silly but i am being sent a workbook each week and
am unsure if the name is going to change. Any help would be great.

Also can you set a macro to copy itself from one workbook to another?


---
Message posted from http://www.ExcelForum.com/