Skip to main content

Excel.CurrentWorkbook

Returns the contents of the current Excel workbook.

Syntax​

Excel.CurrentWorkbook(

) as table

Remarks​

Returns the contents of the current Excel workbook. It returns tables, named ranges, and dynamic arrays. Unlike Excel.Workbook, it does not return sheets.

Category​

Accessing data