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.