How to change the value of a Constant

[Ice Rhino]

I have a constant string value set at the top of a module. This constant is the path to a specific file on my hard disk.

Is there anyway, through the use of a Open File dialog box or whatever that I can change the value of this constant to the selected path?

I have a set of procedures that run on my machine, I want to be able to change the value of the constant if the folder structure is different on another machine on which the DB is being used.

Anybody?

Ice Rhino

 

[chrismcbride]

I would have said that the point of a constant is so that it CAN'T be changed. In fact I think that constants, once declared and initialized, can not be changed.
I would say that you should either make a series of different constants to represent your various use cases or to use regular variables.
HTH
Chris

 

[Ice Rhino]

If I were to use variables, is there a way to specify a variable at the top of a module and then call it from anywhere within the module?

I have 2 dozen Sub that will call this variable.

IR

 

[Ice Rhino]

I will look that up in the help file right now.

Many Thanks

Toni