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