Excel VBA Compile Error for Declare statements on 64-bit
When executing an Excel Integra profile containing macros on a 64-bit Office 2010 installation, the following error may be displayed:
The solution to this error is to add "PtrSafe" after the "Declare" statements in the VBA code. For example "Declare PtrSafe Function ...". Note that this only works for 64-bit and an error will be raised in 32-bit. Please refer to the following Microsoft technotes: http://support.microsoft.com/kb/983043 and http://msdn.microsoft.com/en-us/library/ee691831.aspx.