using If then statement to identify workbook

[vba317]

If I am in a workbook I need to assign a number to a variable. Using my current code I get a complile error. I am using the following code:

If wbCodeBook = "BasicMaterials" Then ALegLowV1 = 477

 

[SkipVought]

Hi,

Not much code. I assume thatwbCodeBook is a workbook object, but that just a wild guess. you need to do better...

If UCase(wbCodeBook[b].Name[/b]) = "BASICMATERIALS.XLS" Then ALegLowV1 = 477

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[vba317]

Skip,
Your right next time I will try and be more accurate. Thanks for your help.