getElementById run-time 13 type mismatch error

Hi everyone,

I have the following simple code that works well on my computer (Windows 7, Excel 2013, IE11) but not on my friend's computer (Windows 7, Excel 2010, IE11). The code errors on the getElementById line. Whenever "getElementById" appears anywhere in the full code, we get a run-time error 13 (type mismatch) on his computer. I've tested getElementsByClassName in the same position and it works fine. It seems like a strange, simple error but haven't found anyone on the forums who's come across this before. Can anyone generate this error? Microsoft HTML Object Library and Microsoft Internet Controls are references. Any help would be appreciated.

Cheers, Rob

Please Login or Register  to view this content.

Thanks for the replies guys.

Pike, thanks for the code, I'll keep that (still an XML beginner and that will help me learn). I guess I'm just trying to understand why this apparently simple code error is occurring.

Leith, thanks for the response. I tried your code as it is written but I'm getting a run-time 424 Object required error that errors on the getElementById line. When I use your code within my full code I get run-time error 91 - Object variable or With block variable not set and an error on the same line.

Cheers, Rob

Thanks for your efforts pike and Leith. pike, your addition got Leith's code working on my computer but unfortunately no effect on the full code on my friend's computer. Same run-time 13 type mismatch error