Daily posts of Excel tips…and other stuff
Archive for the ‘Downloads’ Category.
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 [...]
I use a New Project workbook whenever I'm starting, wait for it, a new project. The idea is that I always have the same stuff in my projects, so why set it up from scratch. At first, it contained the minimum stuff - stuff that was guaranteed to be in every project. [...]
I have a favorites add-in that I use every day. There's always a couple of frequently used files that I can't add to my favorites menu because they change periodically.
One example is my inventory reconciliation file. I have several such files in a folder and they are named InvRecon20081130.xls and InvRecon20081231.xls. I [...]
I love finding big Excel tables, mostly because I hate manually creating sample data for testing. I've written about Contextures Sample Data. Then there's the IRS Tax Statistics page that has many downloadable Excel files. The IRS tables aren't always clean tables. Sometimes they are over-formatted, but they still work.
My latest [...]
