PDA

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:

Dave
03-28-2023, 04:07 AM
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.