Public/ Global variables

Just a quick question I think.....

Public Variables
My understanding was that these are variables which can be used anywhere within the workbook however Ive heard talk of them being available to other workbooks as well?

This seems to be backed up by the following Microsoft article
http://support.microsoft.com/kb/141693

which (in the Public Scope para) states "To make a public variable available to other workbooks, from a new workbook select the workbook containing the public variable in the Available References box of the References dialog box (from a module sheet, click References on the Tools menu)."

Now Ive tried everything to get this to work but cannot seem to share a variable across workbooks, I did manage to "Reference the 2nd workbook" but I cant get it to take the value of the Public Variable on.

Any thoughts/tips/ideas?

You have not shown us what you tried to it's impossible to say whats wrong.

I just did a simple test with two workbooks.
Book3.xlsm with the vbaproject named as PBook3

Please Login or Register  to view this content.

Book2.xlsm with reference to PBook3

Please Login or Register  to view this content.

You can run loadvar or showvar in either workbook to see contents and where the code is running from.

What's the reason for sharing variables across workbooks?

BTW, if you put the Public variables in the ThisWorkbook module of the workbook, you can refer to them as members of that workbook without having to set a reference. Not convinced it's a good idea though!