Defining a global string for entire project

[RSXchin]

I'm about to leave my company, but I don't want to leave them up a creek and unable to edit my code.

To do this, I'm going to make everything super easy on them by putting all the things they would ever update into a module. Mostly filenames.

How would I define (and call) a string variable that is to be used throughout several modules?

 

[RoryA]

Public Const gcstr_FILENAME as string = "C:\blah.xls"

for example.

 

[RSXchin]

yes, but where would I put that? should it go in a class module?

My goal is to have a module of JUST public constants that they would change, and nothing else.

 

[RoryA]

No, just a normal module.
Good practice to do this anyway...

 

[RSXchin]

So I would call it like...

TheFilesName = module1.gcstr_FILENAME

right?

 

[RoryA]

Yes, though you don't actually need the Module1 part.

 

[RSXchin]

Thanks so much. I hope this will be educational to future searchererses.