Prev: Create AD user
Next: demo of Office Web Components Pivot Table Control...
From: mr_unreliable on 10 Feb 2007 13:44
hi gang,

The attached hta is a (primitive) demo of the office
web components (owc) pivot table control. The owc
pivottable control is a "lite weight" control which
allows for showing a pivot table in any actX-friendly
environment (hta, web page, asp, vb, etc.)...

As you probably know, the office web components come
with microsoft office installation. Or, you can
download them directly from msdn. As best I can tell
there are three versions (v9,v10,v11), corresponding
to the version of office you have installed. I have
ofc2k, which included v9. However, ms was generous
enough to allow me to download v10, which is the
version used in this demo.

As you probably know, one can do great things with a
pivot table, if only one could understand it. I have
been searching around, and haven't found too much by
way of demo code, until I ran across this demo on msdn:

http://support.microsoft.com/kb/235542

The demo is a vb demo, but it can be translated almost
one-for-one into vbs.

Hopefully, I can now move on to doing something a little
more challenging with owcPT...

cheers, jw

p.s. there is a second attachment (pivottest.mdb), which
is a little access database, which you will need to run
the demo.

p.p.s. uh-oh. microsoft wouldn't allow me to post this
message, claiming that the pivottest.mdb file was too big.
However, if you have ms access, you can "do-it-yourself"
(i.e., create the database) in about 10 minutes with the
instructions on the kb235542 page.

Or, you could use some other database. For example, there
are numerous copies of the "northwind.mdb" database around
and there is probably even one on your system somewhere.
 | 
Pages: 1
Prev: Create AD user
Next: demo of Office Web Components Pivot Table Control...