I'm currently testing some code for document automation on multi-user environment. For one specific machine there is a error 13 mismatch, where on other the code runs perfectly.
All machines have been installed with the same office version (365); all machines have been updated to the latest version.
When I run the code step by step the following happens:
First iteration:
lstbx.name = "listType"
IsItemInListbox gets called and is set to true
Second iteration
lstbx.name = "listComponent"
IsItemInListbox gets called and is set to true and I get a type 13 mismatch error when the code steps out of the IsItemInListbox.
I can bodge it by using an "On Error Resume Next", however I'm not sure that's the best way to go about it. It's one specific machine that outputs this error, the other machines don't have this. Does anyone know what could be the problem?
Bookmarks