ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Parameters for Office COM Add-Ins (https://www.excelbanter.com/excel-programming/325517-parameters-office-com-add-ins.html)

Mircea Pleteriu[_2_]

Parameters for Office COM Add-Ins
 
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,



Bob Phillips[_6_]

Parameters for Office COM Add-Ins
 
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,





Mircea Pleteriu[_2_]

Parameters for Office COM Add-Ins
 
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,







Bob Phillips[_6_]

Parameters for Office COM Add-Ins
 
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,










All times are GMT +1. The time now is 03:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com