View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
rcl2884 rcl2884 is offline
external usenet poster
 
Posts: 7
Default Identify invalid folder in VBA

I would like users to enter a folder in a worksheet where data will be
stored, but would like to catch invalid folder names in VBA so that I
do not get an error if I pass the invalid folder to the file system
object.

Obviously, I can parse the string myself looking for invalid
characters and counting backslashes etc, but I thought there might be
an easier way to do this. Any ideas?

Thanks, Rick