ITechOasis

Get List of All Files inside Main & Sub Folder – Excel VBA

This is in Continuation with our Previous Post Get List of All Files inside a Folder-Excel VBA  Here we have added Sub Main and put Sub FilesInsideFolder outside main sub . sub clearCells  is to clear all cells before running FilesInsideFolder sub routine. Starting Row  changed from r=2 to  r = Cells(Rows.Count, “A”).End(xlUp).Row + 1 because now when …

Get List of All Files inside Main & Sub Folder – Excel VBA Read More »