VBA Export Data from A Closed Workbook Into A Different Workbook

[LadyRave]

Hello!

I know there are threads that explain how to extract data from one workbook to another and I have TRIED countless times to follow the code, but have been so frustratingly unsuccessful so here I am creating my own specific message. I'll do my best to explain what I need help with.

Here's what I want to do:

1) I have one workbook titled Test.xlsm
2) I have a second workbook titled Outage Info.xlsx
3) I want to take the data from workbook titled Outage Info.xlsx, tab labeled "Sheet1", (while it's closed) and import it into workbook titled Test.xlsm, tab labeled "Data Source". It does not have to be the same formatting.

Data from Outage Info.xlsx

A B C D E

2017
A	000601191186	2017-10-21	2017-11-20	Random Data Here
A	000601193323	2017-08-21	2017-08-25	Random Data Here

<colgroup><col span="2"><col><col><col></colgroup><tbody>
</tbody>

2018
B	000601191201	2018-03-13	2018-03-14	Random Data Here
B	000601191202	2018-03-15	2018-03-16	Random Data Here

<colgroup><col span="2"><col><col><col></colgroup><tbody>
</tbody>

The range I'm selecting is from A1 to E74 from this workbook. I want to extract all of this data and import it into my other workbook tab labeled "Data Source".

How do I achieve this?

May someone please help me?

Thank you.

 

[James006]

Hello,

From THE Excel Guru : Mr John Walkenbach ... himself ...!!!

Excel Tips From John Walkenbach: A VBA Function To Get A Value From A Closed File

HTH