I have over 100 report names in a directory that I want to copy to excel. The only way I have found to do this is to right click on the file, choose properties, in the General tab highlight and select the file name and copy and paste it into Excel. I would like to make this process go much faster and not be so tedious. Is there a way? TIA.
Last edited by paperwings25; 09-17-2013 at 10:23 AM.
you can use the DIR function. Change path and file search pattern to suit
Please Login or Register to view this content.
I would like the macro to just go down the list in the directory and copy them all into excel. Is there a way to do that?
Do you mean the actual contents of those files?
Currently that macro simply lists filenames on a worksheet from specificed folder with a file name search patter of *.xls*
It worked! Thank you!
If I want to copy some PDF names in, would I just change .xls to .pdf in the macro?
yes
Please Login or Register to view this content.
Saved me hours. Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks