MrHanky
11-07-2011, 10:26 AM
Hi,
Im currently trying to create some VBA code for use with SAP BW and its SAPBEX module.
Basically as the BW query returns I want to interrogate and process records from one column.
The first bit is fine but my VBA is out of practice.
As I step through each record I want to test it and if it meets a certain criteria I want to add it to a sort of internal table. Once I have gone through all the records I will then sort and output.
The bit im stuck on is the storage of the records (the internal table). In ABAP I would create an internal table and store there. Is there something like that in VBA?
Thanks, any help is appreciated.
Mark
Im currently trying to create some VBA code for use with SAP BW and its SAPBEX module.
Basically as the BW query returns I want to interrogate and process records from one column.
The first bit is fine but my VBA is out of practice.
As I step through each record I want to test it and if it meets a certain criteria I want to add it to a sort of internal table. Once I have gone through all the records I will then sort and output.
The bit im stuck on is the storage of the records (the internal table). In ABAP I would create an internal table and store there. Is there something like that in VBA?
Thanks, any help is appreciated.
Mark