View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Stefi Stefi is offline
external usenet poster
 
Posts: 2,646
Default finding out File size before opening it

See FileLen function in VBA Help!

Regards,
Stefi


€˛MarkS€¯ ezt Ć*rta:

Hi,
I have to go through a lot of excel files to find which ones are for a date.
That part works fine I go through the directories open all the files and look
inside them.
What I need to do now is in VBA find if the file is ZERO length before I
have opened it

Thanks MarkS