Has anyone developed a drillthrough example using Excel
2000? I understand that Excel 2000 does not support the
PivotCell object...therefore rendering the 2002 example
useless in 2000.

A few months back, someone on this newsgroup had sent me an Excel add-in
that does drill-through in both Excel 2000 and XP. Here is a link to,
and an excerpt of, the thread:

http://groups.google.com/groups?hl=e...8&th=c057dee7f
68b2c67&rnum=7
The recordset retrieved from the drill through has data from all
partitions. The data has just to be pasted into the XL sheet by
looping through all the partitions. Assuming that rst is the recordset
you retrieved, the following code will do the job (it might not be the
best implementation but it works.)

If you're interested I can send you a XL add-in that adds drill
through (multiple partitions) functionality to XL 2000 / XP.

HTH

Thomas
...

- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Thank you Deepak,

Is this all there is to the add-in?

'Get data from recordset to worksheet

intNumberPartitions = 0

Do Until Done

On Error GoTo ExitDo
' repeat until all partitions done
intNumberPartitions = intNumberPartitions + 1
' show current partition
Application.StatusBar = "Pasting Partition: " &
CStr(intNumberPartitions)

Dim strPasteArea As String
' determine next free row
strPasteArea = "A" & CStr(Range("a65536").End(xlUp).row +
1)
' paste data
Range(strPasteArea).CopyFromRecordset rst
' next partition
Set rst = rst.NextRecordset

If rst.State = adStateClosed Then Done = True

Loop

ExitDo:

Do you have any more information than this? This just
looks like the code that handles the recordset, I need the
code to actually determine the cell, the query to send
etc...

Trevor