Excel.CurrentWorkbook

This function retrieves the data found within the current Excel workbook. It will retrieve tables, named ranges, and dynamic arrays. It should be noted that unlike the Excel.Workbook function, this pa...

Syntax

Excel.CurrentWorkbook() as table.

About

This function retrieves the data found within the current Excel workbook. It will retrieve tables, named ranges, and dynamic arrays. It should be noted that unlike the Excel.Workbook function, this particular function does not include sheets in its output.