This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Excel.CurrentWorkbook() as table
Returns the contents of the current Excel workbook. It returns tables, named ranges, and dynamic arrays. Unlike Excel.Workbook, it does not return sheets.
Was this page helpful?
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for