Compare Size of 2 files
 

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

Compare Size of 2 files
 

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

--
Regards,
Tom Ogilvy


"Terri" wrote in message
...
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

Compare Size of 2 files
 

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


"Tom Ogilvy" wrote:

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

--
Regards,
Tom Ogilvy


"Terri" wrote in message
...
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