Prev: [ann] demo of Office Web Components Pivot Table Control...
Next: dotNET in VBScript...
From: mr_unreliable on 10 Feb 2007 14:02
o.k. here we go.

pivottest.mdb compresses nicely, down to a size
that is acceptable for posting to a microsoft
newsgroup.

cheers, jw


From: Paul Randall on 16 Feb 2007 15:17

"mr_unreliable" <kindlyReplyToNewsgroup(a)notmail.com> wrote in message
news:udp1pNUTHHA.3428(a)TK2MSFTNGP04.phx.gbl...
> 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.

I've noticed that many OWC examples use an <object...></object> tag in HTML
or HTA files to display stuff. The ClassID is typically something like:
0002E542-0000-0000-C000-000000000046, and only the two digits after '0002e5'
determine which component (spreadsheet, chart, etc) and which version (10,
11, etc) it refers to.

Two questions:
1) What web search engines will allow me to find OWC sample code by
searching for the strings 'clsid' and '2e5'? Google says it hasn't
catalogged any web pages containing the string 2e5 within an actuall Class
ID string like CLASSID="CLSID:0002E542-0000-0000-C000-000000000046".

2) Although OWC V11 is probably the last version of OWC that Microsoft will
release, OWC continues to be a useful tool for many users. I've found that
one of the best sets of OWC samples released by Microsoft is:

http://download.microsoft.com/download/office2000dev/sample/1/win98/en-us/owebcomp.exe
All use HTML for the user interface; some samples are asp, some are
stand-alone, and one includes a custom control that it uses.

My problem with them is that they use Class IDs that are obsolete. Being a
lazy person, I dislike having to change every instance of an obsolete Class
ID like
0002E510-0000-0000-C000-000000000046 to
0002E5xx-0000-0000-C000-000000000046, where xx are the two digits that refer
to version 10 or 11's equivalent component.

Has anyone found a way to 'fix' the system, by modifying the registry
perhaps, so that the Version 10 or 11's Class IDs will automatically be used
in place of the obsolete Class IDs?

Thanks,
-Paul Randall


 | 
Pages: 1
Prev: [ann] demo of Office Web Components Pivot Table Control...
Next: dotNET in VBScript...