Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a virtual table in VBA Excel
Hi, I want to do something, let's say nonconventional. Last fall, I studied in a Java class, and we created virtal tables in memory where we put data in it. It was purely an object in Eclipse Java program. No database was supporting the data, only the object in memory. So you could get one data by getting it in the precise row in my virtual table when my list was done. It allowed me to creating dynamic tables, where the number of data was not always the same one. Now I want to do it in Excel VBA. You could say, "why bothering with that! Just throw thoses damn values in cells and you'll get the result!" :) Well, I think it's an interesting challenge, and it's simplier in my view once you know the concept. So you can do lot's of mathematic equations with this virtual table. So does anyone can point me something to help me on virtual tables in memory? Thanks Jean-Jérôme Doucet -- Werner ------------------------------------------------------------------------ Werner's Profile: http://www.excelforum.com/member.php...o&userid=24304 View this thread: http://www.excelforum.com/showthread...hreadid=379714 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a virtual table in VBA Excel
Have you looked at using multidimensional arrays? You could put your data into the array and then perform mathematical operations on the array. -- bhofsetz ------------------------------------------------------------------------ bhofsetz's Profile: http://www.excelforum.com/member.php...o&userid=18807 View this thread: http://www.excelforum.com/showthread...hreadid=379714 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Displaying of a cool virtual clock in Excel | Excel Worksheet Functions | |||
Creating a virtual link in Excel | Excel Discussion (Misc queries) | |||
Creating a virtual table in VBA Excel | Excel Programming | |||
Virtual Memory Error when running Excel | Excel Programming | |||
Virtual Memory Error when running Excel | Excel Programming |