if statement bringing up error

Can anyone tell me why this if statement isn't working for me please?

If Range("B6").Value - Range("B5").Value = Windows("Raw data Macro.xlsm").Range("A3").Value Then
[statement to continue copying]
Else
End If

“object doesn’t support this property or method"

Originally Posted by Special-K

Does the file need to be open to do this?
Has the Windows() Object been loaded?

Yes and yes

That works, Thankyou

That if statement is looking at the difference between two dates in a .csv file (in date format dd/mm/yyyy hh:mm), in cells B6 and B5 and comparing it to a 20 second value (in number format 0.000231481481023366) in the "Raw data Macro.xlsm"

I want it to skip the statement below it if it does not equal to 20 seconds. However it's running through the statement every time, even when the time difference is 40 seconds. Any thoughts why this might be happening?

The vba now looks like this:

Please Login or Register  to view this content.