Hi Folks
I've implemented an error reporting macro that sends an e-mail with the error details upon closing the file.
The logic behind this is is, whenever an error occurs during runtime, the error details are logged in a dedicated error table within the same workbook.
Then, upon closing the workbook, a check is done whether the error table is empy or not. If not, a temporary copy of the file is made and send to me via Outllook.
This procedure worked perfectly for some time, but suddenly it makes Excel non-responsive, and after some time I get a message like:
"Excel is waiting for another application in order to complete an OLE action"
This will loop forever!
The line of code that will start the issue looks like so:
dim objOutlook as object
Set objOutlook = CreateObject("Outlook.application")
I've got Outlook running on my system with no issues otherwise
Any ideas?