Hi,
I tried to write a macro that will allow a user to select a folder, then extract how many rows are in each file in that folder, and show them in the workbook.
I.e.
Select Folder
Open File 1
Find last row
Put this in Workbook Cell A1
Open File 2
Find last row
Put this in Workbook Cell A2
etc.
The macro I made is here:
However, it does not work.Please Login or Register to view this content.
If anyone has a better method, or can amend mine it'd be much appreciated.
Thanks!
dvent
Bookmarks