Browse by Tags

String Building Class

I read that someone uses a string builder class in vba. For some reason, that thought had never occurred to me, but I thought I’d give it a try. Here’s my first attempt. Private msText As String Public Property Get Text() As String Text = msText End Property Public Sub Append(sText As String, Optional sDelim As [...] Read More...

Published Mon, Jul 07 2010 7:30 AM by Daily Dose of Excel

Filed under: Classes, CodeCritic

Creating a Parent Class

Hasn’t it been a great class module week? It all started with Rob’s post about custom collection classes, or what I call parent classes. If I make a Person class, I want a People class. If I make an Invoice class, I want an Invoices class to hold all of them. Back in [...] Read More...

Published Fri, Jul 07 2010 7:30 AM by Daily Dose of Excel

Filed under: Classes

Class Property Fixed Values

In my previous post on a Custom Collection Class, I used an example of a People collection with Person items. As well as First Name, Last Name, and City, I had originally included the Gender property (Female, Male, Unknown), but removed it just prior to posting. I purposely left it out because I didn’t want to distract [...] Read More...

Published Thu, Jul 07 2010 3:16 AM by Daily Dose of Excel

Filed under: Classes, VBA Advanced, VBA, VBA Code Library, Enumerations

Public Variables in Class Modules

Rob’s post made me revisit some class module code, so it’s probably going to be class module week. Stop groaning out there. First, a quick discussion on the merits of property statements vs. public variables. Rob comments: I don’t see the point of traditional public property get/set if only to set a private variable. It [...] Read More...

Published Tue, Jul 07 2010 7:00 AM by Daily Dose of Excel

Filed under: Classes, Visual Basic Editor

Adding RibbonX code to an Office OpenXML file using VBA

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, [...] Read More...

Published Mon, May 05 2009 1:42 PM by Daily Dose of Excel

Filed under: Excel12, Classes, VBA Advanced, MVP, Downloads

Excel Dashboard and Visualization Boot Camp

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 [...] Read More...

Published Mon, May 05 2009 11:34 AM by Daily Dose of Excel

Filed under: Classes

Editing elements in an Excel OpenXML file using VBA

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 Read More...

Published Wed, May 05 2009 1:13 PM by Daily Dose of Excel

Filed under: Excel12, Classes, VBA Advanced, MVP, Downloads, Automation, File Operations

Related Sheets Stack

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. [...] Read More...

Published Fri, Apr 04 2009 10:54 AM by Daily Dose of Excel

Filed under: Classes, Userforms and Controls

Quick TTC Output

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 [...] Read More...

Published Thu, Mar 03 2009 12:35 PM by Daily Dose of Excel

Filed under: Classes

Quick TTC Classes

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 [...] Read More...

Published Tue, Mar 03 2009 8:48 PM by Daily Dose of Excel

Filed under: Classes

VBA Framework II

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. [...] Read More...

Published Sun, Dec 12 2008 3:27 PM by Daily Dose of Excel

Filed under: Classes, Visual Basic Editor

VBA Framework

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 [...] Read More...

Published Sun, Dec 12 2008 8:49 PM by Daily Dose of Excel

Filed under: Classes, Visual Basic Editor

Creating Classes from Access Tables

As I mentioned earlier, I want to develop a framework generating app to create some of the code necessary to read and write to and from an Access database. This is iteration 1 of about 100. Start with this table in Access Set a reference (Tools - References) to Microsoft ActiveX Data Objects 2.8 Library. Then run [...] Read More...

Published Sat, Nov 11 2008 10:46 PM by Daily Dose of Excel

Filed under: Classes, External Data

Using a Class Property to do more than just Assign or Query a Value

The purpose of this article is to introduce various capabilities of a class property. It is not meant to serve as an introduction to classes and objects. See the references section for introductory pages. The typical use of a Class Property is to assign a value or to query its value as in the [...] Read More...

Published Fri, May 05 2008 12:03 AM by Daily Dose of Excel

Filed under: Classes, VBA, VBA Basics

Updating Stock Quotes

I answer about four questions a month on the newsgroups. I'm off to a roaring start in April, but I don't like my answer much. I never know just how "correct" an answer to give. So I gave an answer that I felt was appropriate for the original poster and I'll give [...] Read More...

Published Tue, Apr 04 2008 10:49 PM by Daily Dose of Excel

Filed under: Classes, External Data

Syndication

Recent Posts

Tags

News

Archives

String Building Class

Creating a Parent Class

Class Property Fixed Values

Public Variables in Class Modules

Adding RibbonX code to an Office OpenXML file using VBA

Excel Dashboard and Visualization Boot Camp

Editing elements in an Excel OpenXML file using VBA

Related Sheets Stack

Quick TTC Output

Quick TTC Classes

VBA Framework II

VBA Framework

Creating Classes from Access Tables

Using a Class Property to do more than just Assign or Query a Value

Updating Stock Quotes