Hi,
I got in a XLS-File a Function (CheckData), which should be started from another Modul of XLS-File2.
Public Function CheckData(Value As String)
...
in the same modul it works like:
---
res = CheckData(Value)
How can I do that in the other modul / file?
something like:
res = File1.CheckData(Value)
At the moment I load the other sheet, but it gives me an error before (compiling error), because the function is unknown (of course, it hasn't loaded yet...)
THX
I can't copy the function to File2, because the function should be used in many other files as well. Therefore I can't just copy it.";