Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Errors Detected In File Since SP3 | Excel Discussion (Misc queries) | |||
Excel Form File Errors | Excel Discussion (Misc queries) | |||
Problems merging an excel file due to code or file problems? | Excel Programming | |||
xls file size / memory errors | Excel Programming | |||
File location / Version errors | Excel Programming |