Not sure if this will help, but this is what I do. I open workbooks
created by users and they can name them whatever they want. Since I can
never know what they might name them, I just change the sheet name when
these files get to my workbook.

ActiveSheet.Name = "Whateveryouwanttonameit"

I also use a variable to capture the ActiveWorkbook.Name and use these
to address the incoming workbook.

Bruce


--
Bruce001
------------------------------------------------------------------------
Bruce001's Profile: http://www.excelforum.com/member.php...o&userid=26630
View this thread: http://www.excelforum.com/showthread...hreadid=500637