Compare Size of 2 files

[Guest]

Hello!
Can you tell me how to compare the file size of 2 files and if file "A" is
larger than file "B" then MsgBox "Check file". I've been at this for hours
and just can't get anything to work.

Thank You,
Terri

 

[Tom Ogilvy]

If the files are closed then:

lenA = FileLen("C:\MyFolder\WorkbooksA.xls")
lenB = FileLen("C:\Myfolder\WorkbooksB.xls")

If LenA > LenB then
msgbox "Check file"
end if

 

[Guest]

Thank You! Thank You! Thank You! This works great!
Terri