Hi,
You must enable the Developer Tab and VBA Editor in Excel in order to access the Excel object library in Office 365. Here is how you can do it:
- Launch Excel.
- On the ribbon, select the "File" menu.
- From the menu on the left, select "Options".
- Choose "Customise Ribbon" from the left-hand menu in the Excel Options window.
- Check the "Developer" box under "Customise the Ribbon" in the right-hand side pane.
- Click "OK".
Once you have enabled the Developer tab, you can access the Visual Basic for Applications editor by clicking on the "Developer" tab in the Excel ribbon and then selecting "Visual Basic" from the "Code" group.
In the VBA Editor, you can access the Excel object library, which contains objects like Workbook, Worksheet, Range, and more.
Best Regards.