Referencing a Workbook

[Aussiebear]

I see references to a workbook within code which will use the wb then the workbook name. Almost always the workbook name is a single word. What happens if the Workbook name is multi worded?

Could it be wbBlessMeMother or wbBless Me Mother if the workbook is called Bless Me Mother for example?

[Bob Phillips]

Enclose in quotes.

[mdmackillop]

I think you're refering to a variable, so probably
Dim wbBlessMeMother as Workbook
Set wbBlessMeMother = Workbooks("Bless Me Mother.xls")

[Aussiebear]

So i should concatenate the name when using the workbook name as a reference when declaring it as a dim and Set, but keep its "openness" when using it as Workbooks ("Bless Me Mother")

[Bob Phillips]

Can you say that in English?

[Aussiebear]

Don't you mean in Australian.

If I use the Set command then the workbook name needs to be BlessMeMother

If I want to dim the workbook I need to use wbBlessMeMother

However if I refer to the workbook by its name when using Workbooks ("Bless Me Mother"), I need to include the spaces.

If you're coming to Australia Bob, you better brush up on your english:devil2:

[Bob Phillips]

Assuming that the variable is named BlessMeMother, and the book is named Bless Me Mother, then yes, yes, yes.