So on the link you gave me it has this code. From what I understand, if I put this at the beginning of my macros then it should solve it. Is that correct?
' Test whether you are using the 64-bit version of Office 2010.
#If Win64 Then
   Declare PtrSafe Function GetTickCount64 Lib "kernel32" () As LongLong
#Else
   Declare PtrSafe Function GetTickCount Lib "kernel32" () As Long
#End If