Help with compile error on 64bit pc. Works fine on other 64bit pc...

[chrisko]

Im getting a compile error when trying to open this file on my home pc. On my work pc it works fine. Both systems are windows 10 running Office Pro Plus 2013.. I cant do anything since the VBA error continues to pop up...

Thanks,
chris

 

[MARK858]

It is not whether it is a 64bit computer but whether the Excel version is 64bit or 32bit. The computer it is running on will be 32bit where as your Excel version will be 64bit.

Have a read of the link below


https://msdn.microsoft.com/en-us/library/ee691831.aspx