I am trying to create an excel pivot table which gets launched inside a VB application. I think there is two roads I can go by:
1. I can build an SQL statement in VB with some date fields that the user can select, then pass that sql to the excel pivot table. OR
2. I can build a parameter sql statement inside the Excel pivot table and pass the parameters from the VB app.
Either way would work fine for me, but I can't get either of these options to work. I need help, my deadline is approaching. Anyone have any ideas. If so can you SPELL them out, I clueless on this one.