ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Contents of a file (https://www.excelbanter.com/excel-programming/274759-re-contents-file.html)

Tom Ogilvy

Contents of a file
 
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





All times are GMT +1. The time now is 07:24 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com