Only Excel 2016 has the vba library objects to create a power query from vba, older versions are not able to create a query from VB. How different ...
Ok Catalin, let's see what we can do here in the forum. Help me to understand your solution. Again, what I'm trying to do is to set up a list of Go...
Thanks Catalin, I actually found "most" of the answer that I was seeking for this particular issue by watching this video: I still would like ...
Hi Catalin, I'm an Excel novice, and I know even less when it comes to Power Query. I did not have a parameter table. I appreciate your solution, bu...
Thanks Mynda, I couldn't get your suggestion to work, but Excel.CurrentWorkbook() did grab a list of tables/sheets. This gets me to about 80% of...
Thanks Mynda. I appreciate your fast response. So your solution works for a closed workbook, but does it work for an open workbook? If I currently ...