Daily posts of Excel tips…and other stuff
Archive for the ‘Downloads’ Category.
I thought I’d add regular expressions to my Quick Find utility. I’ve used regular expressions about a dozen times in my life, so why not clutter up a simple tool with it. Now if I start my search string with rx: it will evaluate the rest as a regular expression.
My problem is when [...]
In my continuing series of tools to save myself literally seconds every day, I present Quick Move. See also QuickTTC, QuickPivot, and QuickFind.
Even though I’m a keyboard guy, I tend to move or copy sheets within a workbook using the mouse. I generally only use Edit - Move or Copy Sheets when I [...]
Debra at Contextures blogged about creating a word search puzzle while she nursed a hangover (although she won’t admit it). Creating a word search puzzle in Excel seemed like a fun exercise, so I set about doing it.
It’s not even close to finished, I’m just throwing the first draft out there to see what [...]
My previous post went a bit unnoticed, but I bet this one might interest some of the Office developers…
In that post, I showed how to access and modify existing parts of an Office OpenXML package. This opens up the path for us to add ribbon customisation code to an Office file. For this to happen, [...]
Hi Everyone!
Today I finally found time to actually post a brand new article on my website.
Wouldn’t it be useful to be able to edit the contents of an Office 2007 OpenXML file from within VBA? Well, now you can, using the sample code and explanation in this article.
Enjoy!!
Regards,
Jan Karel Pieterse
www.jkp-ads.com
OK, I lied. One more post about TTC. I’ve added RegEx. When I use Text-to-Columns, it’s always for a one-off job. I have a goofy string and I need to get one piece of information out of the middle. It’s never part of a periodic process and I never call [...]
I was trying to get a list of file names from a list of paths I had in column A. I used Data - Text to Columns delimited on “\”. The results are below. I highlighted the file names so you could see my problem.
There were only a dozen or so paths, [...]
Ever since I’ve been using Jan Karel’s Flexfind, I don’t use Excel’s built-in Find. However, about half of the time, I don’t need any fancy options. I just need to find some text in the workbook. So I wrote a utility for myself called DDoE Quick Find. It has the [...]
