How To Use the PivotTable Office Web Component with VB

T

the

I have Access 2003 form I would like to toggle through different pivot
charts of the form data. Using Office Web Components I have created
the VBA that provides rudimentary functionality.

However, I cannot find instructions or help on how to:

- group x-axis values by 7 (ie, values are days and want to group them
by 0-6, 7-13, etc).

- sort data ascending/descending

I've been searching high and low ... MS KB, in newsgroups or on web.
It appears that using OWC with VBA is either new or just not used (and
discussed) very much. The help that is available is frustratingly
cursory such as:

How To Use the PivotTable Office Web Component with VB
http://support.microsoft.com/kb/235542/EN-US/

Any help will be greatly appreciated!

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

OWC 11 Spreadsheet with VB .NET - Install 0
How to configuration the spreadsheet in XP Web Component 1
Web Component Newb - Trying to diagnose error msg. - Please help 0
Using PivotTable web component to report Form results on a webpage 3
How to add a combo box in a cell using the office web component 11 0
How do you use Shaped Data in a PivotTable? 1
How to deploy my web application with Office Component Toolpack? 5
How to display Building Blocks with "Gallery "(one office component ) 0

Top