Problems with 64-bit Excel 2010 and API Calls

[ransomedbyfire]

I am trying to edit some VBA written a while back using API calls to an investment program to make it compatible with Excel 2010 64-bit. I have replaced all the "long" types with "longptr" and added "ptrsafe" to the functions where needed. But now, I am getting type mismatch errors on some of the functions that take long type data for an argument. Why is this happening? Is it possible that the API call just doesn't know what to do with LongPtr data because it was written a long time ago? How can I get around this?

 

[RoryA]

Not all longs should be changed - only those that refer to memory addresses.

 

[ransomedbyfire]

Thanks, rorya.

I forgot to mention, I tried declaring the trouble-making items as variables, and the code still didn't work. But I'll look further into the information you provided.