Module to automatically fill a sheet with file names and data?

[ajmoore0351]

Hey all,

I made this account to ask this question. I haven't been able to find a working solution anywhere else, so hopefully someone here would be willing to help me.

I am trying to get a spreadsheet to list the names of files inside of a folder and add new entries when a new file is placed in that folder. I am also trying to get additional columns on that page to display certain information from inside those files. Most of the files are word docs, but some are PDFs or PowerPoint. My desired end-state is that whenever I open the spreadsheet, it automatically lists all files in the specified folder in the first column, with all pertinent data in subsequent columns. Any help would be greatly appreciated.

[Leith Ross]

Hello ajmoore0351,

Welcome to the Forum!

Listing the files in the folder is quite easy. Before writing the code to do that, what specific file information did you want in the other columns?