excel training uk - Array's or creating virtual tables and populating | Excel forum

Hi Stephen,

Just to give you some background on my current role...I work as a Business Intelligence Developer, using Business Objects (BO). Sometimes when some of the core functionality falls short of the user's requirement we may need to use VBA to output the desired results, apply filters etc. The way the (BO) works is that we form a connection via ODBC to our source database and using SQL we return a data set. Sometime as explained already we need to use VBA. The course tutor advised me that the best way would be to use arrays. I don't know if this is the best way? But what I was looking to achieve was a way in which one would create a virtual table, populate it with data from you source data. Do some manipulation, comparisons etc. Assign the values to a display vars and display these on the final report. Your colleague also mentioned that a course in VBA for Access would possibly be a more appropriate course for what I need in as far as VBA goes.

In answer to your questions...I suppose in the context of Excel and conceptually your right, therefore I would be grateful for your help and would love to see how you would all the above in any case.

Many Thanks,
Sunil.