Help with Open File from Directory

[MarianneBal]

Dear Superusers,

Could someone please tell me how I can add the 'select file from directory' for below mentioned code?

Currently the code is picking all files that are in the folder location, however, I would like to select them.
Tried couple of things but failed...

Thanks for your help!

Please Login or Register  to view this content.

[arlu1201]

Try this

Please Login or Register  to view this content.

Change it as per your requirement.

[MarianneBal]

Thanks Alrette for the Quick Reply - can you help me with adding a directory to this as well?

[MarianneBal]

Thanks Alrette for the Quick Reply - can you help me with adding a directory to this as well?

And I would need to select multiple files.

[arlu1201]

Use this line

Please Login or Register  to view this content.

(change it to your system path)

before the code i gave you.

[MarianneBal]

Hello again,

It's not working - I also need to select multiple files...

Any suggestions?

[arlu1201]

What error are you getting? I tested it at my end and it works. When it prompts you to open the file, the folder you have selected will popup.

To repeat for multiple files, do you want a popup asking "Do you want to open another file?" ?

[MarianneBal]

Hello Arlette,

With the code I want to get a POP UP where I can selecte multiple files.

From my selection I want the code to copy the first worksheet in the Active Workbook.
(this part does actually work, but with my code mentioned above it picks automatically all files in the folder)

For another sheet I have a code that allows me to select multiple files, but I'm somehow not able to 'merge' those 2 codes.

The Code with the multiple file selection that works is:

Please Login or Register  to view this content.

[arlu1201]

Do you mean select multiple files at one time itself, using the Ctrl key?

Is there a specific reason why you want to personally (i mean physically) select the files instead of having the macro do it?

[MarianneBal]

I would rather have the possibility to select the files manually, as the files are in different folders every month and as I won't be the only user, I rather not want other users overwriting the code.

Yes, Multiple files with Ctrl key.

Furthermore, I was wondering if it would be possible to add the value of a Range to the name of the new Worksheets (that were copied to the active workbook)?

Thanks so much for your help!