smdawson

June 9th, 2010, 01:46 PM

Previously all of my questions about C++ have been answered very helpfully (@dwhitney67 & @MadCow108). Hopefully you guys know VBA as well ;)

For a project at my summer-internship I need to know how to split a 16b binary line into two arrays(or vectors?) of 4b and 12b, using VBA. I am not familiar with VBA and have trouble following the syntax at this point.

(i.e.) 1111111111110000 >>(split into 2 arrays somehow)

array1(12b) = 111111111111

array2(4b) = 0000

After this I will perform some simple binary calculations with the two pieces of information.

If you could point out any VBA reference material as helpful as cplusplus.com and learncpp.com is, that would be appreciated!

For a project at my summer-internship I need to know how to split a 16b binary line into two arrays(or vectors?) of 4b and 12b, using VBA. I am not familiar with VBA and have trouble following the syntax at this point.

(i.e.) 1111111111110000 >>(split into 2 arrays somehow)

array1(12b) = 111111111111

array2(4b) = 0000

After this I will perform some simple binary calculations with the two pieces of information.

If you could point out any VBA reference material as helpful as cplusplus.com and learncpp.com is, that would be appreciated!