PDA

View Full Version : Processing records in VBA



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

mdmackillop
11-07-2011, 11:46 AM
Check out this current thread (http://www.vbaexpress.com/forum/showthread.php?t=39330).