Parameters for Office COM Add-Ins

  • Thread starter Thread starter Mircea Pleteriu
  • Start date Start date
M

Mircea Pleteriu

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,
 
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)
 
How to set an environment variable?

Bob Phillips said:
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)
Click to expand...
 
You set it in windows, via the Control Panel>System dialog.

In Excel, you get it with code like

Debug.Print Environ("myVariable")

--

HTH

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