RefTreeAnalyser: Two updates

Hi There,

It’s been a while since I last posted here. Today I have released an update of my RefTreeAnalyser utility.

The tool now allows you to add a Table Of Contents to your workbook which contains lists of all sheets, all charts and all Pivottables:

In addition I have added a Feedback button to enable my users to send their complaints -I mean compliments- directly to me! So as of now, if you have ideas for improvements or suggestions for additions or a bug to report, use that feedback button!

Be safe!

Jan Karel Pieterse

Excel VBA Masterclass

Hi there. Hope you and yours are well in these difficult times!

This is just a very short announcement that I’ll be doing an on-line version of my Excel VBA Masterclass.

The training is scheduled for May 18, 20, 26, 28, June 2, 4 and I’ll be using Microsoft Teams to deliver it to your homes!

Register now!

Regards,

Jan Karel Pieterse

Ribbon customUI Text Editor

Over at my site, yoursumbuddy, I’ve published an Excel addin for creating, editing and validating the XML that makes up Excel Ribbons. I developed it because I can’t install executables at work and want an addin that I can just run from Excel. It works on ribbons in workbooks and addins and runs in Excel 2010 and later.

Along the way I learned about XPATH, SAX, and DOM as they relate to XML and VBA. I’ve already forgotten what those things are and how they work, but they were important for a tool that downloads customUI/customUI14 XML, validates multiple errors, creates and/or modifies the .rel entries, and then uploads it all back into the zip file that is an Excel workbook. Whew. Should you care to learn more, my unpassword-protected code is available for your reading pleasure. If you poke around you’ll see that my code is built on the work of Jan Karel Pieterse, Ken Puls, Ron deBruin and even keepitcool. Thanks to all of them!

Here’s a couple of pictures of the addin form:

form with tips

form with highlighted error

To learn more and download the addin, just visit the yoursumbuddy Ribbon customUI XML Editor page.

Table tools add-in

Based on an idea by fellow Excel MVP Frédéric le Guen I have created a new small Excel add-in which makes your life using tables in Excel slightly easier. It sports a ribbon tab which contains a drop-down containing all tables in your worksheet so you can quickly jump to them and another one which displays all columns in the current table. Both items are also available in the cell right-click menu. The former when you right-click on a cell not in a table, the latter when you click on a cell within a table.
It also has an enhanced “Insert table” dialog which enables you to enter the name of the table and has the Headings checkbox turned on by default no matter what:
Insert table dialog

Check out a slightly more elaborate description and a download link

Enjoy!

Jan Karel Pieterse

Summer sale at jkp-ads.com

Hi there!

Now that summer has arrived I’ve planned a summer sale. From July 1st up to July 10th I offer a 25% discount on both products I sell:
RefTreeAnalyser
and
The Excel File Remediation Utility
To get your discount, just go through the purchasing process and enter this coupon code to redeem your discount:
JKPADS-Summer2015

Regards and have a great summer!

Jan Karel Pieterse

www.jkp-ads.com