Go to the Data tab in the ribbon and select Get Data from the Get & Transform section. Create a From Folder Queryįrom any workbook that you want to create a file inventory in, you can create a From Folder query. With Power Query this would have been a much less time consuming task and with no coding needed. We were using Excel 2010 and installing the Power Query add-in was not an option due to IT security lock down. Fortunately for me, my department used only a few folders and subfolders for our work otherwise I would have tried to modify the code to loop through all subfolders in a folder.
Each department was responsible for using this to take inventory of all their files. We created a VBA procedure that would take a folder path and spit out all the file names in that folder.
I worked at a large insurance company and we were in the midst of a project to take inventory of all the spreadsheets used.
Keeping track of all these can become a job in itself. Excel is awesome! But with so many people using Excel in large companies, the number of spreadsheets used can become quite massive.
0 kommentar(er)
