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