Declaring a Variable Constant (Sort Of)

[emmahope206]

All,

I need your help. I have the following scenario in Access 2003.

• Module1 - contains a extensive list of Public Constants such as file paths, file names etc
• Module2+ - contain extensive coding that is used for many reasons

Please note i cannot change Module2+, add modules or change the incoming file name.

The problem is as follows, we now have a file that contains a date stamp in the name. Essentially I need to do the following:

• Public Const str2ImportFileDay1 = "ESD Cust Feedback trial" & format(date, "yy-mm-dd") & ".xls"

I know I can't do this, I know I can declare a Public Variable and define the value in the subsequent modules but this isn't possible as I can't change the subsequent modules.

Can someone advise a way around this?

Thank you for your help.

[June7]

I don't think the code in Module2+ care if the str2ImportFileDay1 entity is a constant or variable.

Maybe declare str2ImportFileDay1 as a public variable then in some code that executes when db opens set its value. Problem with this is interruption of code execution will wipe out the variable value.

Only other thing I can think of is custom classes/collections, something I've never done.