Scoping Public Variables Across Workbooks

Hi

I have a problem with defining variables.

In have a workbook called mybook1.xlsm. At the top of a code module within that workbook I have a public variable declared

Public kdatabase as string

I can use that quite happily in any code modules within mybook1.xlsm.

But if I refer to that variable in a sub that is in my personal.xlsb then i get an error

For example i haver this sub in a code module from the perosnal.xlsb

Sub AddDb
kx=kdatabase
....
End Sub

This generates an error when AddDb when it is called from a sub in mybooks1.xlsm.

Does this mean a public variable is only available to subs from within the same workbook?

If that is not the case how do I define my variable so that it can been seen from both workbooks?

Thanks

Max

Thank you for your replies.

I tried defining the variable but couldn't get anywhere with that. So I have used your idea Richard and save my variable in a worksheet within Personal.xlsb.

I'm not sure if this is recommended practice but it works! So hey ho.

Max