Thanks for looking at this.

If I'm assuming correctly that you put the code like this 

Option Explicit

#If VBA7 Then
Private Declare PtrSafe Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)
#Else
Private Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)
#End If

Public sRMSnumber As String, sForce As Variant, sOfficer As Variant
Then I'm still getting the same error.

Both versions of Office are 32 Bit.

The only reason I introduced the delay is I read somewhere (can't remember where) that this worked, although its not happening with my project.