Referencing a workbook with Codename in a variable.

I want to find a workbook when the CodeName is in a variable.
If I have the Name in variable sName then

Workbooks(sName) gives me the workbook.

So when the CodeName is in a variable sCodeName, how can I reference the workbook that it belongs to?

Hi foxguy
Perhaps this (untested)

Please Login or Register  to view this content.

Hello Foxguy,

The Code name for an object can only be found by walking the collection of objects the code name belongs to. In Excel there are only 3 collections have CodeName properties:Charts, Workbooks, and Worksheets. The Active workbook's CodeName is always "ThisWorkbook". Worksheet code names are like Sheet1, Sheet2, Sheet3, etc. Here is an example that assigns an object variable to the object with the CodeName in sName.

Please Login or Register  to view this content.

Leith;
Thanks for confirming what I already believed.