View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Antnonio Castro Antnonio Castro is offline
external usenet poster
 
Posts: 2
Default 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?