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.