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....
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).
I don't understand what you want to say me ... i think that i must to modify the form code .... is it ?
Last edited by Aussiebear; 03-28-2023 at 01:14 PM. Reason: Removed the unnecessary quotation
Seems like a similar post here...
Macro VBA error form Recursive Search | MrExcel Message Board
Dave
It's the same post, i published in another forum VBA .... i am crazy with this code, i need help!!
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.
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
Originally Posted by Aussiebear
Ok I understand. It will not happen again . Sorry again.
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.
Show you in this image , the target :
Excel 1 has only one column with random names
target_excel.jpg
For Select the source folder, you must to slect one option from the form
The file excel called EXCEL 1 is the next file
Last edited by Aussiebear; 03-28-2023 at 01:13 PM. Reason: Removed the unnecessary quotation
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.
Last edited by Aussiebear; 03-28-2023 at 01:12 PM. Reason: Removed the unnecessary quotation
Posting Permissions
Reply With Quote
