Macro to Open File & Copy Data

Hi

I've got a workbook which i want a macro on it, which needs to do the following:

1. Open a specific file (with a dialog box to choose the file if possible)
2. Refresh all of the data in the newly opened workbook (there are 90+ sheets with external data on them)
3. Go to the master sheet in this workbook and select a range and copy it.
4. Return to the original workbook and paste the data.
5. Close the workbook that we opened and save the changes.

The workbook i have is too big to post here, however if someone could show me the basics of the VBA that would be created from this, i think i could edit it to fir what i want to do.

Thanks

James

Hi,
any ideas anyone?

James

Hi,

Cheers for that, i'll go into more detail now, what i want to do is:

1. Open a file (selected by the user)
2. Refresh all of the external data
2. Select the range A2:J9201
3. Copy the range
4. Paste the range (values only) to cells A2:J9201 in a tab called "COMBI" in the original workbook
5. Close the user-chosen workbook (saving changes)

James