Public Const doesn't seem to work

[Airfix9]

I have some code in a file called "Z-BUTTONS FY06 (New).xls":

On a module called "Constant_DB"

Public Const cstZB As String = "Z-BUTTONS FY06 (New).xls"

On a module called "ARF_New"

Workbooks(cstZB).Activate
    ActiveWindow.Visible = False

When I try to run the code, I get a Runtime Error 9 - Subscript out of range and I'm tearing my hair out trying to work out why!

The reason that I added these constants to a separate module is that many procedures in the file will refer to them and I want to be able to change them quickly and easily.

Hope that's clear enough - any help gratefully received. Of course, it is entirely probable that this is a simple issue and I can't see the wood for the trees. The file compiles fine, however and the Immediate window returns the correct value for cstZB when asked.........

 

[Norie]

The first thing to do is check the name is correct, including any errant spaces.

 

[Airfix9]

AAAAAAAAAAAAAAAAAAAAARGH!!!!!

Told you it was simple.

** Beats head against desk and vows to stop drinking! **

Thanks, mate...