Data from SAP.
The objective open the excel data and copy to my main excel
MyPath = Application.Path & "" & "BT.xlsx
Workbooks("BT.xlsx").Activate <---- U got debug issue can't find the path
Sheets("Sheet1").Select
ActiveSheet.Copy After:=Workbooks("Raw.xlsm").Sheets("existingRaw") ' ~~ This is file and sheet name ~~