I have a large application in VB 6 that uses collections to handle passing data from an input program to an activex dll. For example the collection contains 4 different Propertys defined as doubles or singles.
When I intialize the class I automatcily add 120 items so that the user can pass their data from an array or grid to the dll. IE:
The user addresses the collection as follows
input.outlays(x).Loans = 1500.00
input.outlays(x).Withdrawls = 200.00
The problem is the large time and overhead it takes to create the collection with 120 items at the Class initalization. What I want to do is convert this to use a UDT of arrays ie:
Loan as Double
Withdrawl as Single
Public myVar as Outlays(120)
I would like for the user to be able to use the same syntax as above to set the values if possible and if not possible how would you accomplish this.
I’ve seen a number of people looking for examples of how to access web services from VB6. I’ve been using a test harness I built in VB6 (using many resources I found online) that I use for small projects to work out how to communicate with web serv…
When designing a form there are several BorderStyles to choose from, all of which can be classified as either 'Fixed' or 'Sizable' and I'd guess that 'Fixed Single' or one of the other fixed types is the most popular choice. I assume it's the most p…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code.