View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nick Hebb Nick Hebb is offline
external usenet poster
 
Posts: 162
Default Brainstorming possible file errors/problems

I have a routine that traverses a network directory, opens any Excel
file, checks for some data, updates and saves the file if necessary,
then closes the file.

I'm trying to brainstorm a bunch of test cases, so I can handle each
error/ problem gracefully. So far I've come up with:

- network connection failed
- read permission denied
- change permission denied
- file is password protected
- file contains macros
- prompted to update linked data

I wrote something similar about 5 years ago, and I seem to recall that
my list was much longer. Can anyone think of other opening, saving,
closing problems that might occur?

Thanks in advance.

Nick Hebb
BreezeTree Software
http://www.breezetree.com