Hi all.
Newbie here. When trying to do a blank query to combine existing tables in the current workbook I cannot get the function Excel.CurrentWorkbook() to correctly load the list of tables in the current workbook.
All I'm getting is the standard header (Content and Name) with nothing listed.
I did manage to load it correctly before but cannot seem to get it right now. Any ideas or any setting I may have changed inadvertently?
thanks in advance.
Bookmarks