Allow User to Choose File to Open

hi, i am looking to create a macro that will allow a user to select a file to open. Once the user has selected the file, I would like to copy all values in that file from Cells A to X and then copy it back to the original file.

I have managed to get some help in writing the following code:

Please Login or Register  to view this content.

But this only opens the file, so i was hoping somebody could help me get a bit further.

Thanks in advance.

Glytch,

Please read the Forum Rules and then edit your post to wrap your code with Code Tags.

Done.
Sorry to fast to help that missed on that part.

Glytch, thanks i will give that a go and let you know how i can get on. Thanks once again.

I have managed to use the code that was kindly written by Glytch and I have also added some code to copy the required data from the file that has been opened. The following is the code:

Please Login or Register  to view this content.

Where I am struggling is to close the workbook that has been opened after the data has been copied. I have added the code but this gives me a "compile error, wrong number of arguments". Could any1 please help?

Thanks in advance.

I generally use object variables when using external workbooks.

The code below declares a Workbook object and sets it to refer to the opened external workbook.
Then the Range.Copy Method is used to do the copying.

The code I've used for the copying is very similar to the Range.Copy Method example in Excel Help, with the addition of Workbook references.

Please Login or Register  to view this content.

Thanks T-J, i will give that a go and let you know how i get on.

If that doesnt do the the trick you can always see the attached file.

Here you have a macro that you can copy a sheet from a closed workbook.

Glytch