View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Eric G Eric G is offline
external usenet poster
 
Posts: 30
Default Why Isn't This Working?

Thanks Jim!

I did a small test - I looked at the Err object while I ran my code. When
it hit the first bad file, its value became 70. When the code ran "On Error
Goto 0", Err reset to 0. That seems to indicate that it does clear the
error. However, my code still didn't work...

I made one small change to yours - at the end I had to add "Set ts =
Nothing", but otherwise your code worked and fills my need, which is to find
all the files that have permission issues.

Eric