Hello,

I have inherited a small project where we handle inventory data in
excel. The way it's done now is simple: Use fixed columns and import
data about the products from database 1, then loop through the colums
and import details about the products from database 2 and so on.

Problem is that the size and complexity has grown over the years, so
now the macros is full of special cases and is slow and error-prone. I
would like to have the products in some data structure instead of
importing them directly into an excel sheet.

If I was to rewrite it in C++ I would know how to do:
1. Make the products ojects.
2. Put pointers to the objects in a vector that holds info about all
products.
3. Make a map or something that links unique product id to pointers to
the products.

Then I could easily add new products, look up the old and so on.

I know that I can make objects in Excel VBA, but does VBA OOP have any
serious limitations compared to C++ (or C#, or Java...)? What about
performance?

Best Regards
Fredrik