Here's what I would like to do -
I have an old version of a form and I need to create a button on my new form that would open a dialog box and allow the user to browse to their workbook and open it. Then I will copy the data from the old workbook and paste it to the new one. The copying and pasting I can handle, its the opening of the old workbook that i need help with. I have no way on knowing what they have named there OLD workbook. I know there has to be a way to do this. Any ideas and suggestions are appreciated!!


Thanks!! This is driving me !!