You set it in windows, via the Control PanelSystem dialog.

In Excel, you get it with code like

Debug.Print Environ("myVariable")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Mircea Pleteriu" wrote in message
...
How to set an environment variable?

"Bob Phillips" wrote in message
...
You could set a registry value or you could set an environment variable.
Both would be simple to retrieve in the add-in.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Mircea Pleteriu" wrote in message
...
Hi,

Is it possbile to have parameters for COM Add-Ins.
Something like.. to set the value of a parameter within the registry
and
the
addin will automatically read the parameters's value?

Thanks
Mircea,