Excel.Workbook how do I list worksheets from "this workbook"

[Joyner]

Hello, I am trying to use =Excel.Workbook() to list all of my sheet names. I see the syntax:

Excel.Workbook(**workbook** as binary, optional **useHeaders** as nullable logical, optional **delayTypes** as nullable logical) as table


But for **workbook** how do I say "this workbook" without specifying the actual path because I want to use this on any workbook.

Can I do that?

Thank you for any assistance you may have.

 

[Yongle]

Try this ...

Dim ws As Worksheet, List as string
   For Each ws in ThisWorkbook.WorkSheets
     List = List & vbCr & ws.Name
   Next ws

MsgBox List

 

[Joyner]

Thanks Yongle,

Sorry I wasn't clear, I am not looking for a VBA solution, but Power Query,

Thanks