Creating excel file for the names of nonusable files

Hi,
I have been devised a maros for my department.This main macro extracts data from 60 / 70 excel files in folder.If the row 6 of the data files is not filled, then macro is not allowed to extract data from that file. I want to get the names of the files whose data is not extracted by macros.I am also attaching the macros and data file folder for example.(please adjust maro link locallt to your machine and then to folder)

Will you help me in this?

Regards,

Harry

1) Add this to your Dims:

Please Login or Register  to view this content.

2) Expand this section to use the string when needed:

Please Login or Register  to view this content.

Then put this at the very end to show your list:

Please Login or Register  to view this content.

You can always write that out somewhere, too.

You can skip all that stuff above and do this instead.

1) Create a sheet called BadList
2) Edit this one piece of code to write to that sheet

Please Login or Register  to view this content.

Make it:

Please Login or Register  to view this content.

Can you please post up the complete current code as it exists now so I have something to work from? Thanks.

1) Correct your desktop folder, "REMAINING" is misspelled. (fixed in the macro)

2) The simplest thing is to add this in the macro before the loops start:

Please Login or Register  to view this content.

3) I tried to streamline the whole macro just a wee bit, see if this works for you as a replacement. If not, just add the code in #2 above into your code before the lobjfile loop starts.

Please Login or Register  to view this content.