We have a code when called, the currency amount is passed to. If the currency is US Dollar, it's ok.
However, if Canadian currency is sent gives a run-time 13 type mismatch error.
We know it has to do with the regional setup of the computer (we think).
results is 0
Also CDbl, CDec, CLng, CULng, etc.
Please advice on the correct method to go about it.