by ooli

You can download the xls flie here : http://www.filedropper.com/exlcomtestrelease

On 64-bit machine there is a compiling error when you launch. Remplace:

Public Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)

with

#If VBA7 And Win64 Then

    Public Declare PtrSafe Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As LongLong)

#Else

    Public Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)

#End If