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: 110
Default What is the best way of collectiong as much debug info as possible when users hit problems.

What is the best way to collect information about errors when my users
hit a problem so that I can solve them offline and remotely and let my
users continue?

I would really like more information than the Err object provides. Of
course, Err.Number & Err.Description are useful but I would really
need more information for proper debug such as the line of code that
threw the error ,call stack and current context (i.e. ActiveSheet etc
etc). Is this possible or is the Err object the limit of problem
description?

I figure if I could extract all this information I could have my error
handler mail the dump to me and let the user continue.

Does anyone have any ideas or web resources that discuss this issue?

Cheers for any thoughts in advance.

Chrisso

 
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
How to debug formula problems Stefan Froehlich Excel Worksheet Functions 1 October 24th 08 05:49 PM
Best way??-one WB, many users entering only their own info Ed Excel Programming 2 April 12th 07 10:32 PM
Protection in Excel - how do i hide some info. from some users? michael Excel Discussion (Misc queries) 13 December 21st 05 03:32 PM
Can I lock info in Excel 2003 and users in Excel 2000 enter info? Mimmsan Excel Discussion (Misc queries) 1 September 8th 05 12:12 AM
Collectiong data from SQL server / Repeat! Sh0t2bts Excel Programming 2 October 31st 03 11:55 PM


All times are GMT +1. The time now is 07:04 AM.

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"