Hello, I have struggled for 2 days with the attached form and finally got it working.
I will really appreciate, if someone can review and suggest improvements or just point out plain mistakes.
The objective was the following:
- Find all excel files in a folder (XLS, XLSX, XLSM, CSV)
- Pick one of the found files and copy particular data from it (worksheet => cells range)
- Paste the data in another file from the same folder (worksheet => cell address)
Attached is the form (user_form_v5.xlsm). Your constructive criticism is more than welcome.