I am using Win10 x64 + Office 2016 x64. My client Win10 x64 + Office 2010 x32.
I have an excel file, which has some modules & Forms in it, and works flawlessly in Office (Excel) x64.
However, when I try to run it on my end, which is on Excel 2010 x32, as soon as it's opened, the VBA editor fires up and gives me the following error:
(I declare my long Vars as public on top of module).
Compile error: Type mismatch 13
My guess it comes from Long variable.
I am no good in VBA, however, after digging over the Internet, a few websites proposed that for 32bit Excel with 64bit Excel, we should amend (for each declaration) the codes to something like that:
I can't work it out myself
I try Long , LongPtr when declare variable & still have the problem