Sub getworkSheetsFromAnotherWorkbook()Dim wb As WorkbookSet wb = Workbooks.Open("C:\temp\excel_MBC2_old\BASE_POS-NewCI0005088.xlsx", ReadOnly:=True)For Each ws In wb.Sheets Debug.Print ws.NameNextwb.CloseEnd Sub