theta
04-13-2012, 09:06 AM
I have googled for a solution but cannot locate one.
I have macros running on machines that I do not have physical access to. When errors occur, I have to go to the machine to reproduce the issue and then investigate.
I would like to put together some VBA that will run on the local machines whenever the workbook is opened - recording all Debug and Error (trapped and untrapped) into a CSV file in a default file location e.g. C:\Windows\Errors.txt (or .csv)
People can then send me the error log and I can have a look and see what is going on...
Would also like it (if possible) to dump all variables and constants and their values at the end of this file if a full untrapped error occurs i.e. an End / Debug msgbox appears to the user
Any help appreciated ?
I have macros running on machines that I do not have physical access to. When errors occur, I have to go to the machine to reproduce the issue and then investigate.
I would like to put together some VBA that will run on the local machines whenever the workbook is opened - recording all Debug and Error (trapped and untrapped) into a CSV file in a default file location e.g. C:\Windows\Errors.txt (or .csv)
People can then send me the error log and I can have a look and see what is going on...
Would also like it (if possible) to dump all variables and constants and their values at the end of this file if a full untrapped error occurs i.e. an End / Debug msgbox appears to the user
Any help appreciated ?