Hi

I am using Power Query because it does not require to open the source WB to fetch data. I am facing two problems

1) It fetches data as a table (while I need it in a simple range)
2) It does not (Or may be I don't know) import named ranges.

I want to bring a complete sheet from a closed workbook along with its named ranges without opening the source book.

Help would be greatly appreciated


Best Regards
Imran Bhatti