Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training uk - Array's or creating virtual tables and populating
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
excel training uk - Array's or creating virtual tables and populating
Resolved · Low Priority · Version Standard
Reply Tue 4 Dec 2007, 15:52Delegate Sunil said...
Sunil has attended:
Excel VBA Intro Intermediate course
Array's or creating virtual tables and populating
I want to know how I can create table within my VBA code to do manipulation on the original data and then populate my array with the results.
For upcoming training course dates see: Pricing & availability
RE: Array's or creating virtual tables and populating
Hi Sunil,
Thankyou for your question
Could you please just confirm that you want to do the following, in the following order
Create a new worksheet
Populate this with data from another worksheet
Manipulate the data in the new worksheet
and then copy the results to an array
Regards
Stephen
Reply Fri 14 Dec 2007, 10:39Delegate Sunil said...
RE: Array's or creating virtual tables and populating
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.
|