how use office 2010- 64 bit - for all versions and different kernel without any errors

[abdelfattah]

hello
I work at Office 2010 is a 64-bit , but I encounter a problem that my files that I save with the extension xlsb on this version. it does not work on other versions, sometimes occures errors because of the different version or the difference in the kernel
if is there any some lines code add before the code to overcome any error because of the office version ?

 

[Dan_W]

If your XLSB files have VBA code in them, and it's not working on other versions, it sounds as though you are making API declarations in the code, like:

Declare PtrSafe Function ...

Is that the case?API Declarations in 64-bit differ from 32-bit declarations, and will cause errors if you try and open either of them on the other system. To avoid this, you need to use conditional compilation, this an instruction to VBA to parse one part of the code and not the other. It looks like:

#IF VBA7 Then
   ....
#End If

If want the code to then work on 32-bit systems, you will need to provide the corresponding 32-bit versions in the body of the conditional compilation. There is some useful guidance in the comments of the following Mr Excel thread: PtrSafe needed for Win10 64 bit but what about older systems?

Hope that helps.