Making Long variables work in 64 bit AND 32 bit Excel VBA -
i have quite complex excel vba project runs on 32-bit systems, trying make work 64-bit systems too. have resolved function declarations, still issues long data type. doing research, come (from msdn pages): the actual data type longptr resolves depends on version of office running in: longptr resolves long in 32-bit versions of office, , longptr resolves longlong in 64-bit versions of office. but mean can change dim statements from dim x long to dim x longptr should everywhere? or have got wrong end of stick? there circumstances won't work or change should avoided? try longlong. spec, looks longlong replacement 32 type long.