Hi All,
I have the following piece of code which assigns a file name:-
I currently have it stored behind a button on a form (part of a procedure).
There are many different modules, but whenever a different module executes “new_file” it returns a blank string.
Where is the best place to store the code so that all modules recognises the string “new_file”.
Thanks in advance,
Paul.
I have the following piece of code which assigns a file name:-
Code:
Dim new_file As String
Dim direc As String
direc = "H:\"
new_file = "Report_(" & Format(Now(), "yyyymmdd-hhmmss") & ").xlsx"
I currently have it stored behind a button on a form (part of a procedure).
There are many different modules, but whenever a different module executes “new_file” it returns a blank string.
Where is the best place to store the code so that all modules recognises the string “new_file”.
Thanks in advance,
Paul.