Hello,
I have cells (A1:A50) named with 8 digit number each.
Also, I have database (~400 files) in c:\files. They are named with 8 digit number with prefix .xls. For example 12345678.xls 25687452.xls
I need a macro which can find those 50 files (from A1 till A50) in all database and copy them elsewhere (let's say c:\selected).
Hope it's clear enough and sorry for my bad English.
Thank you very much for your help.
Tomas
Edit: This copies all file in a folder. I will need to incorporate the selected files from range.
Something like this should work (it tested successful on my side).
Please make a copy of your workbook and test on the copy.
Please Login or Register to view this content.
Perhaps it was the Noid who should have avoided me...
If you are satisfied with my solution click the small star icon on the left. Thanks
1. Make a copy of your workbook and run the following code on your copy (just in case)
2. With excel open, press ALT+F11 to open the Visual Basic Editor (VBE). From the "Insert" menu, select "Module".
3. Paste the code from above into the empty white space. Close the VBE.
4. From the developer tab, choose "Macros", select the Sub Name, and click "Run".
Thank you for quick answer.
This code copy all files from "FromPath" to "ToPath".
I need that this code copy files only according to filenames mentioned in A column.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks