look at the

if fileLen("c:\myfolder\mycsv.csv") = 0 then
msgbox "File is empty"
End if

--
Regards,
Tom Ogilvy

"Joe" wrote in message
...
Hello,

I am writing a vba macro and my input is an excel file
saved in .csv (command delimited). How could I write a
code in vba to check the contents of "myfile.csv" is blank
or no data at all.

Need your help please.

Thanks
Joe