debxxx1
New Member
Hi Genius people,
I have 2 workbooks. Let's say one is X.xlsb and one is Y.xlsb. (X.xlsb is a production file which I can't modify means I can only modify Y.xlsb)
In X.xlsb I have a public variable
How can I get the value of this public variable in Y.xlsb?
I have tried using below but it does not work.
Please help
I have 2 workbooks. Let's say one is X.xlsb and one is Y.xlsb. (X.xlsb is a production file which I can't modify means I can only modify Y.xlsb)
In X.xlsb I have a public variable
Code:
public const publicVar ="123"
How can I get the value of this public variable in Y.xlsb?
I have tried using below but it does not work.
Code:
Application.Workbooks("X.xlsb").publicVar
Please help