finding all empty excel files in a folder.

J

jackm1

have a windows xp directory and in which hundereds of excel fil
resides. Some of those files are empty. is there a code any one of yo
all have that can search through the entire directory and find al
those files and highlight them or move them to another folder. I woul
truly appreciate some help here.
Thanks.
Stasi
 
B

Bernie Deitrick

Stasi,

What does "Empty" mean? All the cells are blank? Certain cells are blanks, with formulas/constants
in others? There is only one worksheet?

HTH,
Bernie
MS Excel MVP
 
J

Jim Cone

Bernie,
The question is also posted in the programming group.
He may mean empty folders?
Jim Cone
San Francisco, USA


Stasi,

What does "Empty" mean? All the cells are blank? Certain cells are blanks, with formulas/constants
in others? There is only one worksheet?
HTH,
Bernie
MS Excel MVP
 
J

jackm1

ok.
first cell has a date.
all other cells has nothing.

all the other files have
first cell date.
other cells data.

emty file=first cell date
other cells= nothing.

if someone can help me locate all the empty files, it would be great.
thanks, i appreciate you looking into this.
 
M

Michael

Go to View and select details. Then click on the size column to sort your
files by size. I imagine your empty workbooks will have the fewest bytes.
 
Top