Is it at all possible to code a macro to send me an email when an error occurs detailing the fault?
Any help would be appreciated.
Thanks
Is it at all possible to code a macro to send me an email when an error occurs detailing the fault?
Any help would be appreciated.
Thanks
Shouldn't be too difficult. You'd need to have an error handling routine in each subroutine and, in the error handler, pass the details of the error to a subroutine or function which generates the email.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Thanks for the rep
It's been a while ... do you want to share your solution?
Regards, TMS
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks