Error on passing parameter array to Invoke VBA with different types

I’d pass in as string, to overcome the .Net issue I’m facing then convert that to integer in the VBA script. But that moves the problem into the VBA where data types not enforced at coding, only run-time.

I have a solution, just not one I’d like/prefer.

.Net experts out there?

1 Like