Excel User Group

Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

Sign in | Join | Help

Daily Dose of Excel » All Tags » Classes » Collections (RSS)

Browse by Tags

Daily Dose of Excel

Home

Syndication

Recent Posts

Tags

News

This site is published here by kind permission of Daily Dose of Excel's owner Dick Kusleika

Archives

Sorting a Custom Collection Class

I’ve been following Dick’s VBHelpers Build series (1, 2, 3) and his last post reminded me that, from time to time, I need to sort a collection of items in-memory. I don’t have to sort all that often, so my approach has changed over time. I’ve kind of settled on the following. Let’s say I have a [...] Read More...

Published Mon, Oct 10 2011 2:50 AM by Daily Dose of Excel

Filed under: General, Classes, VBA Advanced, Collections, VBA, Downloads, VBA Code Library, Modules
Another Disconnected Recordset Example

I had to do some pretty extensive filtering recently and employed disconnected recordsets to speed up the code, which it did. Except that I ran into a bug, or so I thought. When I made the ADODB.Recordset variable a private module level variable in the class, I got a run time error. [...] Read More...

Published Tue, Apr 04 2011 9:27 AM by Daily Dose of Excel

Filed under: Classes, Collections
Disconnected Recordsets in VBA Classes

I read VBA Has No Class over at Excel Do, Dynamic Does with interest. Bob says: As you can see, the disconnected recordset can do everything a collection class can do, but without having to hand-roll any of the methods, recordset has them builtin. I’m not ready to give up collection classes yet. But I [...] Read More...

Published Thu, Dec 12 2010 10:43 AM by Daily Dose of Excel

Filed under: Classes, Collections

Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.