Re:How can I get this 8 year old VBA 64-bit compiler bug fixed?
by clausok on Monday August 16, 2021 @01:06AM
(#28195103)
If you use collection classes in vba you can run into this bug pretty quickly. Last year I deployed an Excel add-in to a client that enabled them to run Snowflake queries concurrently from vba and this line:
If queries.FilterHasError().Count > 0 Then
was being evaluated as true even when the count was zero.
I had developed the add-in using 32-bit Excel. This was an extremely confounding troubleshooting experience. Eventually Google & Stackoverflow rescued me from believing I was going crazy.
I had developed the add-in using 32-bit Excel. This was an extremely confounding troubleshooting experience. Eventually Google & Stackoverflow rescued me from believing I was going crazy.