-
Sure thing :thumb
One thing that pisses me off a bit with Excel VBA forums is the amount of people who are saying "Power Query can do that". Yes, it's new to Excel, but I'd put my money on it coming from a Database background! Just a thought but maybe a new PQ forum should be set up :whistle:
-
Sorry about that rant, give me six pints and off I go!
-
I am not familiar with Power Queries, but if they use SQL then they are obviously of database origin.
I think it is good that MS recognised that many people use Excel for databasing and have continued to develop that side of it, it has come a long way since the days of Visicalc. Excel it not just a spreadsheet anymore and with VBA automation it is very powerful.
-
I haven't looked at them yet either, it's another 'to-do' item on the list!