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
[TABLE="width: 695"]
<colgroup><col span="2"><col><col><col></colgroup><tbody>[TR]
[TD]2017[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]000601191186 [/TD]
[TD]2017-10-21[/TD]
[TD]2017-11-20[/TD]
[TD]Random Data Here[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]000601193323[/TD]
[TD]2017-08-21[/TD]
[TD]2017-08-25[/TD]
[TD]Random Data Here
[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 695"]
<colgroup><col span="2"><col><col><col></colgroup><tbody>[TR]
[TD]2018[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]000601191201 [/TD]
[TD]2018-03-13[/TD]
[TD]2018-03-14[/TD]
[TD]Random Data Here[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]000601191202[/TD]
[TD]2018-03-15[/TD]
[TD]2018-03-16[/TD]
[TD]Random Data Here[/TD]
[/TR]
</tbody>[/TABLE]

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