In Excel 2010 I used this code to import sheets from a closed workbook in the same folder as my master workbook:

ActiveWorkbook.Sheets.Add Type:=ThisWorkbook.Path & "\" & "OTHEREXCELFILE.xlsx"
In Excel 2013 this command seems to crash the Excel Application. Is there another way to import sheets from a closed excel file into a master excel file? Or is there a way to prevent Excel 2013 from crashing?


here is the problem signature for the error:

Problem signature:
Problem Event Name: APPCRASH
Application Name: EXCEL.EXE
Application Version: 15.0.4551.1510
Application Timestamp: 528be48d
Fault Module Name: EXCEL.EXE
Fault Module Version: 15.0.4551.1510
Fault Module Timestamp: 528be48d
Exception Code: c0000005
Exception Offset: 00054191
OS Version: 6.1.7600.2.0.0.768.3
Locale ID: 1033