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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |