Global variable

[keenanbr]

Is there any awy I can make a variable global across different templates. I open a second template from a macro in the first template and i need a variable to be available to both.

 

[firefytr]

Hi there,

Here may be some options ...

Store variables in:
Cell(s) of worksheet(s)
An addin (invisible)
Registry
CustomDocumentProperties
Static variables

Post back if you need further assistance.

HTH

Regards,
Zack Barresse

Simplicity is the ultimate sophistication. What is a MS MVP? PODA
- Leonardo da Vinci

 

[keenanbr]

I managed to achieve it thus;

in the first template i call;

ActiveDocument.SetMemberNumber (lMember)

and in the second template I have the macro;

SetMemberNumber(LmemberNo as long)

Thanks for your help.