Daily posts of Excel tips…and other stuff
Archive for the ‘VBA Advanced’ Category.
Last month, Debra lamented:
It’s a tedious process to go through the list individually, especially since the Show Details doesn’t stay open.
I started working on a solution, but quickly grew tired of it. Then today, The Grumpy Old Programmer posted some ruby code to find the date certain blogs were last updated. It renewed [...]
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
I need to do a VLOOKUP but find occurrences later than the first one. I’ve listed out all of my assemblies and all of their component parts like so:
Parent Child Quantity
To list the the children of a particular parent, I need a function that can find multiple occurrences of the parent. I considered [...]
Hi all,
So after Dicks (nice to read) Alive and Well , let’s do some Excel/VBA stuff again.
I intend to get a bit of discussion on this one, so bear with me.
I’m currently developing an Excel workbook for a customer. One of the interesting things with this project is that it consists of multiple data tables, [...]
Hi all,
For a project I needed a quick way to display the content of an array to the user. I didn’t want to use a worksheet, but opted for a userform. The data I wanted to show was contained in an array. The array contained something like:
Description
Before
After
Cell Errors
100
10
Corrupt Names
1000
0
Unused styles
232
0
So I figured I’d put a [...]
gullible.info sez:
An average Microsoft Excel spreadsheet document has 1,102 rows and 18.2 columns.
I say:
That’s 470 rows and 25 columns. I had 408 sheets whose last cell was A1, i.e. blank. I attribute that to two things: I probably have quite a few workbooks that are just code; Most of the workbooks I get [...]
I have four objects that are all dependent on each other. They are CInvoice has many CInvoiceLines, CInvoiceLine has many CRoyaltyLines, CRoyaltyLine has many CRoyaltyAdjustments. In order to properly terminate all of these class modules, I need to remove any and all dependencies. If I don’t, the classes will stay alive and [...]
