Dear All,

I have a big workbook in which the user allow to do multiple tasks like filling forms and able to create new forms based on the data etc. What I want to do that I want to add a button on the workbook opening page as "Open Existing File".

This button should allow user to select a file from his/her personal computer and and with the macro I will instert the button will copy the data in the selecting file to the same formatted sheet in my big workbook.

More simple, there is a semi filled form in somewhere of user's own computer and I want them to copy the data in it when they open the workbook and click the open existing file and copy button to avoid them to re-enter the same data in the big workbook.

Can you help me on this?

Regards,

Emre