Open external workbook and copy paste from it

Hi,

I have the following recorded code to open, copy and paste the data required to specific destination, however the file name and/or destination may change... is there a way of setting the code so it pops up with a file open screen so I can select the relevant workbook?

The following will remain unchanged:

Sheet name - "Sheet1"
Range to copy - "A1:BM500"
Paste destination sheet "QL_TB"

Please Login or Register  to view this content.

Many thanks in advance

Hi colin
try this code
The code will open a dialog to select your wb and then copy the range("A1:BM500") from the selected workbook
The copied data will be pasted in the workbook which has the code in sheets("QL_TB")
Hope it is the required

Please Login or Register  to view this content.

Regards

Hi Yasser,

This works perfectly, however the format of the copied cells are completely different - is there any way of retaining the formatting?

Thanks very much

Actually - it's ok, this still works for what I need - thanks again!

Hi colin
to retain the formatting you can replace this line

Please Login or Register  to view this content.

with these lines to paste copied data as values only

Please Login or Register  to view this content.

Regards