This is a small example of how I managed to automate Excel via the Excel UDF (COM Automation) whilst avoiding COM errors when the user interacts with Excel at the same time the script is running. Though this might be useful because I've spent most of a day solving this, and I haven't seen a good solution in the forums yet. This topic solves the COM errors that occur when a user interacts with an Excel workbook whilst it is being automated via the Excel UDF. These errors can occur when calling