View Full Version : Sleeper: Recursive folder search
OFFICE365
03-28-2023, 02:03 AM
Select the source folder, and search for matches with the excel 1 file.
The files that exist in excel 1 will be searched in the source folder and copied to the destination folder.
I need help about one menu for selecting the source folder, because which one doesnt give the value to the main code....
arnelgp
03-28-2023, 03:20 AM
set your Column count of your combo to 2.
then you put on each (2nd column) the path of each folder (see the code on userform).
OFFICE365
03-28-2023, 03:42 AM
I don't understand what you want to say me ... i think that i must to modify the form code .... is it ?:banghead:
Seems like a similar post here...
Macro VBA error form Recursive Search | MrExcel Message Board (https://www.mrexcel.com/board/threads/macro-vba-error-form-recursive-search.1233633/)
Dave
OFFICE365
03-28-2023, 04:11 AM
It's the same post, i published in another forum VBA .... i am crazy with this code, i need help!!:banghead:
Aussiebear
03-28-2023, 04:15 AM
Welcome to the VBAX forum Office365. Whilst we appreciate that you chose to post your query here, it seems you also posted elsewhere ( called Crossposting). No doubt you'll tell us you didn't know..... Please read the rules regarding Cross posting. I'm pretty sure its a rule on all forums who deal with VBA.
OFFICE365
03-28-2023, 04:19 AM
Welcome to the VBAX forum Office365. Whilst we appreciate that you chose to post your query here, it seems you also posted elsewhere ( called Crossposting). No doubt you'll tell us you didn't know..... Please read the rules regarding Cross posting. I'm pretty sure its a rule on all forums who deal with VBA.
Ok I understand. It will not happen again . Sorry again. :hi:
arnelgp
03-28-2023, 04:28 AM
you download the xlsm file i uploaded and test your subform.
then you will know what i meant.
also there is no "filename" in sheet1.
you provide a sample sheet with some data.
OFFICE365
03-28-2023, 05:39 AM
Show you in this image , the target :
Excel 1 has only one column with random names
30686
For Select the source folder, you must to slect one option from the form
The file excel called EXCEL 1 is the next file
OFFICE365
03-28-2023, 08:35 AM
Yes, I have seen something, maybe a litte improvement, but I think that when the form is going to send the route to the main code, it is lost , and the main code finishes. I dont understand.
Powered by vBulletin® Version 4.2.5 Copyright © 2025 vBulletin Solutions Inc. All rights reserved.