finding all empty excel files in a folder.
 

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


--
jackm1
------------------------------------------------------------------------
jackm1's Profile: http://www.excelforum.com/member.php...o&userid=25399
View this thread: http://www.excelforum.com/showthread...hreadid=388722

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


"jackm1" wrote in message
...

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


--
jackm1
------------------------------------------------------------------------
jackm1's Profile: http://www.excelforum.com/member.php...o&userid=25399
View this thread: http://www.excelforum.com/showthread...hreadid=388722

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


"Bernie Deitrick" <deitbe @ consumer dot org wrote in message
...
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


"jackm1" wrote in message
...

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

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.


--
jackm1
------------------------------------------------------------------------
jackm1's Profile: http://www.excelforum.com/member.php...o&userid=25399
View this thread: http://www.excelforum.com/showthread...hreadid=388722

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.
--
Sincerely, Michael Colvin


"jackm1" wrote:


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.


--
jackm1
------------------------------------------------------------------------
jackm1's Profile: http://www.excelforum.com/member.php...o&userid=25399
View this thread: http://www.excelforum.com/showthread...hreadid=388722