String problem

[LEXCERM]

Hi All,

I have the following piece of code which assigns a file name:-

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.

 

[Norie]

Paul

Why seperate modules?

And what do you mean by 'drag'?