LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Errors Detected In File Since SP3 Karine Rivet Excel Discussion (Misc queries) 0 August 18th 06 06:12 PM
Excel Form File Errors hartleydc Excel Discussion (Misc queries) 0 September 29th 05 11:20 PM
Problems merging an excel file due to code or file problems? Cindy M -WordMVP- Excel Programming 0 September 14th 04 02:58 PM
xls file size / memory errors Stuart Bazzard Excel Programming 2 April 26th 04 11:28 AM
File location / Version errors Michael[_28_] Excel Programming 2 March 1st 04 09:04 PM


All times are GMT +1. The time now is 12:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"