Power Query; How to use Excel.Workbook Function

Hi,
I've been using the Excel.CurrentWorkbook function to bring Tables , named ranges etc into power query and it's fairly straight forward.
If I have a workbook saved on the desktop and want to use 'Excel.Workbook , how do I do this,
suppose I open Excel , new worksheet, get data ; blank query and in the formula bar; Excel.Workbook( ? do I enter the file path? When it say binary workbook do I just type 'yes' or true or something else? , I've been looking at the MS DOCs site and trying various things but none seem to work.
I haven't attached anything as it's not a problem with a specific file or workbook more a general enquiry.


Richard.

Hi Rorya,
Yes, but I still not sure how to bring in just sheets ; I've looked at the code after using 'From file' but that's not much help when
it comes to editing it to just bring in worksheets for example.
BTW I like your Lab, at least think it's a Lab.

Rd

No, I hadn't but I have now and yes it's brought in what I expected.
Thank you very much.
Provided it'll let me I'll give you a rating and close thread.

Richard.