Simple Import Data From Another WorkBook PLEASE HELP!!!

[somebody113]

Okay, this is super simple, I can’t seem to find the EXACT answer I’m looking for..
All I need is a simple macro to import data from another workbook.

I have a Master File called “Master.xlsx”

and

.csv file called “Extract.csv” that refreshes every hour. I have a imacro setup to refresh that

I need a macro that pulls from columns A-G on “Extract.csv” and pastes the info a sheet inside of “Master.xlsx” called “PDump”

So…

Extract.xlsx
Sheet - Sheet1
Columns A-G

TO

Master
Sheet - Pdump
Paste Starting at cell N3

I’d like to run this macro from “master” and its fine if it constantly overwrites the data

This is the closest thing I could find to what I'm looking for, but it does not work!

ChDir _
"S:\Operations\Oper\Analysis\KPI\FY'04 KPI & Month End Spreadsheets\Monarch\SKU backup"
Workbooks.Open Filename:= _
"S:\Operations\Oper\Analysis\KPI\FY'04 KPI & Month End Spreadsheets\Monarch\SKU backup\rwp381.xls"
Range("A2:L15").Select
Selection.Copy
Windows("Model.xls").Activate
Sheets("LinesOnly").Select
Range("A2").Select
ActiveSheet.Paste
End Sub

 

[somebody113]

Oh, one slight thing, since "extract.csv" is a .csv file, there is no sheet name, nevermind that