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
ON-DEMAND: Microsoft Excel - Macros & VBA COURSE DESCRIPTION Learn to automate your most repetitive tasks at the push of a button with Excel macros and VBA. In this online course that Ken Puls designed and built with a company
ON-DEMAND: Microsoft Excel - Basic & Advanced COURSE DESCRIPTION Looking for an Excel course online to improve your skills and save you time? Ken Puls has worked with a company called GoSkills to help design and build Basic and Advanced
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
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
