Reg string public const

[David]

Hello

I am trying to assign a registry value (install path) to a public constant.
I am reading the registry via a function so it will not assign it to a
Public Const arguement.

Is it possible to do that?

David

 

[Dymondjack]

Constants need to be hardcoded and cannot contain variable information of any
sort.

Unfortunately, I don't believe believe it is possible to do what you are
asking.

 

[David]

Thanks

I didn't think so
That will save me time fiddling with no avail.

David

 

[Dymondjack]

I should take that back.

There is a way to access the text in the VBA window, in which case it may be
possible to insert a line that would declare this constant for you, but you
would need someone far more experienced than I, and I'm not sure that it
would be worth the trouble, or even work.

 

[Dymondjack]

http://www.cpearson.com/excel/vbe.aspx


this explains how to go about it if you want to try