I noticed this morning that it has been 23 days since I’d written anything on here. Oops .. sorry! It’s just been one of those few kinds of weeks where real work takes place of my Word VBA hackery.
However, I haven’t been slacking (as per the previous post) for VBA work. The Excel spreadsheet which I’d added a few extra bits to is in full use by our Service Centre staff.
The PowerPoint add-in has been enhanced and now includes various checks for the use of the correct company font – different fonts are used depending on whether it’s an internal, or external, slideshow.
My Word add-in has been ticking over after a colleague requested an additional few checks were added to the Custom Styles inspection code. She’d come across a document which was a bit of a mix of our internal styles, plus copied & pasted text (with styles) from the client. Whilst not quite on a “dog’s dinner” level of style mixes, it did need fixing.
So I’ve added Base Style, In Use? and Locked? parameters to the list box that appears. Although I’m still in two minds about ‘In Use?’ as it’s not, it seems, to be read as a “is this style used in the current document?’ as I initially thought it would.
The Base Style option will probably be the most useful addition as it will show you the original style that any particular style was based on. This should help you track down those wayward styles that have been imported during a copy & paste from another document.
All being well, the v1.81 of the add-in will be released at some point in early May. There’s quite a few bug fixes and speed-ups but not everything I wanted to fix will be in it – mainly due to time constraints.