finding out File size before opening it
 

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

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