VBA: Copying data from another opened workbook to the current workbook

[donatepresent]

Hi Everyone,

I need help figuring out how to copy a fixed data range from another Workbook with a fixed file name (i.e. COA.xlms) and paste to the current/master/active Workbook that does not have a fixed file name(dynamic). Both Workbook will already be open, but the problem for me is how to get the copied data back to the current/master/active Workbook that the VBA is running on.

Thanks,
Ken

 

[donatepresent]

In that case change .Range("A1") to .Range("I3")

Hi Fluff,

The code does not do anything. I don't see that it has copy from the workbook or pasted.

 

[Fluff]

It should paste the data into sheet5 of which ever workbook is active when the code is run.

 

[donatepresent]

It should paste the data into sheet5 of which ever workbook is active when the code is run.

Opps, I had it .xlsm when it should have been xlsx. Thank you it works great!

 

[Fluff]

Glad to help & thanks for the feedback.