Admittedly, to solve this problem in an awkward way is easy (e.g. making use of a string containing the file to be opened), but I want to solve it nicely.
The problem boils down to the following.
I want to open several files consecutively.
There's a chance this fails for some of them.
In that case, a new file should be made.
If I raise an error, the event handler knows the string Err.Description.
Err.Description shows the missing file, but how can I retrieve the file name as a single string?
Using Mid() is not an option, as I get a Dutch description, but some other user probably gets it in another language.
I hope one of you guys can solve this!