Yes I did check the references. One class module needs a reference to DAO which exists. The other class module uses late binding and codes against the Cognos Power Play OLE Automation Object. I use late binding since the type library is not installed on other client machines that will use the...
This type of functionality when dealing with large lists is best handled in a database. Use MS Access if you have it. Create two tables and include your customer records.
Access has two Query Wizards:- Find Duplicates and Find Unmatched. The wizard will quide you through the mechanics.
Hope...
Some very strange things have happened with an Excel 97
spreadsheet I have been developing.
I had created two class modules to deal with getting
external data.
I had code behind a worksheet which handled options
selecteted in listboxes embedded in the worksheet.
I also had a couple of...
Hope this code helps.
Function QueryAndIncrement() As Integer
Dim db As Database
Dim rst As Recordset
Dim strSQL As String
strSQL = "Select Field2 from Increment"
Set db = CurrentDb()
Set rst = db.OpenRecordset(strSQL)
QueryAndIncrement = rst.Fields("Field2").Value...
Some very strange things have happened with an Excel 97
spreadsheet I have been developing.
I had created two class modules to deal with getting
external data.
I had code behind a worksheet which handled options
selecteted in listboxes embedded in the worksheet.
I also had a couple of...
I have written a class in Excel to wrap Poweplay API functionality. I have one method which instantiates an instance of a powerplay report. During testing the visible property was always set to True. Subsequent methods of the class manipulate a Report object which uses the GetObject function to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.