Browse for excel data files to import

[Snoopy2003]

Hello,

I have an Excel application.
My user has many input files (all of them in the same format).
I want to write a moudle which will :

- open a file browser in which the user will select all the data files by once.
- go over the selected files : open each file and copy data to one excel file.

Can you help me or tell me where can I find an example to this task ?
Thank you

[Snoopy2003]

Hello,

If you can help me with the first part I'll be thankfull.

I wish that after my sub will open file browser and after the user selects some files
it will fill an array with files names/paths.

Thank you for your help

[royUK]

Here's some code that I use, you can test it & adapt it yourself. It will only copy data, not the header rows

Please Login or Register  to view this content.

[Snoopy2003]

Hello,

Thank you for your help. It really hepled me.

Thank you

[royUK]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save