Can you access public variables in a different worksheet?

[Kalen Brunham]

Does anyone know if it is somehow possible to access VBA variables declared
as public in an excel workbook from a different workbook?

For example, workbook1 has

public test as integer

in module1 of the VBAProject.

From a different workbook can I access it something like:

Workbooks(1).module1.test

Thanks.

 

[Stephen Bullen]

Hi Kalen,

Does anyone know if it is somehow possible to access VBA variables declared
as public in an excel workbook from a different workbook?

For example, workbook1 has

public test as integer

in module1 of the VBAProject.

From a different workbook can I access it something like:

Workbooks(1).module1.test

If you use Tools > References to create a reference from one book to the
other, all the public variables declared in the referenced workbook can be
seen in the referencing workbook too.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.oaltd.co.uk