Compiling a list of file names(Word documents) from specific folder into excel spreadsheet

[LawnManDan]

Hey everyone, totally new here and looking for some BIG help.
I understand a little about VBA and the basics of making Excel work for me, now I have a big idea.

I would like to create a routine that automatically adds the file name(all .Doc files) from a subfolder on my computer to the Excel file we have made to track our production. We produce anywhere from 5 to 30 sheets a day per person and are hoping to have this system allow them to be updated automatically. The end goal is to see when the file was created and use the corresponding columns to track follow-up and close rates.

[macropod]

Try something along the lines of:

Please Login or Register  to view this content.

[LawnManDan]

Thank you!! This seems to work well for importing the information. However, it does not update when I close and open the file. Is it possible to have it add the new files that we are creating daily?

[macropod]

If you want it to run automatically when you open the workbook, change the macro's name to Auto_Open.

[bakerman2]

This one also gives you the date the file was created in Column B.

Please Login or Register  to view this content.

[bakerman2]

Thanks for rep+.