We require a simple example of a VB2010 program that creates one or more pivot tables based on entries in a worksheet. The attachment includes [url removed, login to view] containing a worksheet, IPROF , of some financial transactions. Also a shell VB2010 program is attached which calls generatepivot. The project is to write generatepivot .
The is a simple project (probably under 75 lines of code) with anyone familiar with pivot tables, VB2010, etc. Fuller details are given in the attachment including an example copied from elsewhere
The test of whether it works will be:
1 Enabling VB2010 to drive this
2 Testing by changing generatepivot parameters.
3 A compiled version which we can re build from source