Reproducing a bug / error reported by user

[imranbhatti]

Hi,

Sometimes users report some bugs / errors with screenshots and even identify the line of code that the execution stops at. But the error is not reproduced on our machine.

What are the best techniques to reproduce an error?

What might be the differences between our machine and user's machine?

(Because you can't fix a problem if you can't reproduce it)
My question is specific to Excel VBA.

Best Regards
Imran Bhatti

 

[Joe4]

(Because you can't fix a problem if you can't reproduce it)

That is not always true. Many times the error message will tell you exactly what the issue is. Sometimes, it is very obvious, based on the error message. If you do not understand what it is telling you, you can do a Google search on the error number and error message, and it often leads you in the right direction.

Here are some things which cause errors that you will want to check:
- What version of Excel are you using, and what version of Excel is the other user using?
- On the computer where it works, in the VB Editor, go to Tools -> References and check which libraries are selected. Do the same on the computer where it is failing. Are any libraries missing?
- If the macro is accessing specific files, do both computers have the same drive mappings and permissions?