GetOpenFilename() errors
When I use "s = application.GetOpenFilename()" I have two options: a) s =
False (boolean) because I canceled the function; b) s = the selected file (no
boolean).
When I use Y = ubound(s), Excel displays a 13 error, if s = False.
When I use a "if s = False then.." statement, Excel displays a 13 error if s
= the selected file.
I had tried the "on error resume next" instruction but it does not
function.. How can I deal with this situation?
|