In the good old days, it was easy to check the application version in Office with VBA. You just used a little test of Val(Application.Version) to return the number. 12 was Office 2007, 14 was Office 2010, 15 was Office
Slobodan emailed me to describe a trick to protect Excel tables that he is using to drive data validation lists. The data validation lists are sourced from tables loaded via Power Query, and leverage a little hack to hide them
One of my favourite add-ins of all time just got an upgrade, and I’m super stoked about it. Why? Because I can use it again! As I began my VBA journey, there were two add-ins that I used all the
Some time back I posted a routine to refresh Power Queries with VBA, allowing you to refresh all Power Queries in a workbook. Things Changing… The challenge with that specific macro is that it refers to the connection name, which
I got a comment on my blog the other day from David, asking if we could make Power Query prompt for a folder at refresh, allowing us to choose which folder to should be used to consolidate files. That sounds
When I’ve finished building a solution in Excel, I like to give it a little polish, and really make it easy for my users to update it. The last thing I want to do is to send them right clicking
If you’ve ever built a PivotTable that contains hyperlinks, you’ll notice that clicking the hyperlinks doesn’t do anything. This can be a bit frustrating as the reason you put that field on the Pivot in the first place is that
Yesterday I made a comment on Twitter that I was trying to figure out if it would be faster to check the conditional formatting formulas in 40 workbooks manually to ensure they were correct, vs writing a tool to do
It's always nice when you go to a forum and someone gives you a nice bit of VBA code that is supposed to accomplish your goals. But if you've never used VBA code before, it's kind of hard to know
Over several years of participating in forums, and working on my own projects, I always felt it was a bit awkward to create and send new emails through Excel. Invariably, every time I found that I needed email code, I
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
