Excel VBA equivalent to System.IO.Path.GetInvalidFilenameChars

[Johnny C]

System.IO.Path.GetInvalidFilenameChars is the list of valid file name chars in vb.Net

Is there an equivalent setting in VBA?

I can't get into the registry here at work, IT have locked it down to prevent people like me from tinkering

 

[Norie]

Johnny

I've never seen such a built-in list in VBA but I have seen functions that will check for invalid filenames and they usually include a hard-coded list, e.g. Const strIllegals = "\/|?*<>"":".