--- In [email protected], "Sheri" <sheri...@...> wrote:
> Maybe for version .72, it would be enough to remove Pass II. Lets see if > there are any Type Mismatch errors. It's worse than I remembered. E.g. local objSheet = appRef.ActiveWorkbook.Worksheets(1) an alias for local objSheet = appRef.ActiveWorkbook.Worksheets.Item(1) fails with DISP_E_EXCEPTION (not DISP_E_PARAMNOTFOUND or DISP_E_TYPEMISMATCH, the "correct" error messages when type of an argument is wrong) if argument is presented as a BSTR. Because error isn't DISP_E_PARAMNOTFOUND or DISP_E_TYPEMISMATCH, I get no feedback about what argument's causing the problem, so have to loop through all if them (in this case, just one) and guess what type to omove to for each. I'm going to include wholesale type-guessing for the DISP_E_EXCEPTION situation as well as targeted guessing for DISP_E_PARAMNOTFOUND/DISP_E_TYPEMISMATCH case. And as said previous, ways you can turn all guessing off if you want to see what happens without it. Be next week now.
