Daily posts of Excel tips…and other stuff
Archive for the ‘Classes’ 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, [...]
The second Excel Dashboard and Visualization Boot Camp takes place Wednesday through Friday of next week, May 20-22, 2009, in Frisco, Texas. There are a few spots remaining, and it’s not too late to sign up.
Excel MVPs Mike Alexander and Jon Peltier are teaming up for a repeat of last October’s successful boot camp. Join [...]
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
In Previous Sheets Stack, I created a historical list of sheets visited on the right click menu for easier navigation. After reading the comments, I decided to change the whole approach. Now I show related sheets (which I define) in a userform.
Related Sheets
I’m dealing with inventory assemblies, so the relationship is already defined. [...]
OK, one more post about Text to Columns, then I’ll quit. I have two basic outputs coming from this code. I need to populate a listbox (zero based array) and the destination range (one based array). I created the List property to spit out either based on the OneBased argument.
Public Property Get [...]
In my DDoE Quick TTC utility, I use two classes; CSplit and CSplits. I really wish I was better at naming classes. But this pair sticks to my usual singular-plural pattern. CSplits is more or less a collection class that holds all of the CSplit instances. I turned out to be [...]
See VBA Framework for the first revision.
For this revision, you can select which VBProject in which to add the code and you can identify a parent class.
I refactored the code to use a class module to make the code more readable. Concatenating strings is always messy, so I hope this helps a little. [...]
In Create Classes… I had this todo list:
Create the class module rather than copy and paste
Name the class module based on the table name
Select the database and table from a list on a userform
Establish Parent Child relationships between two classes
Create functions to fill the class from a recordset
Create a userform to add/edit/delete records
I need to [...]
