PivotDetailRange

[Effie Ram]

Hi
I've created owc11 PIVOT , no problems, working smoothly
I need to retrive the value from the data grid AFTER the user click on it to expand it
(say that before the expand there is the Total number of Employees, after expand/click there is the list of thier ID and the names
so... (from the help file
--------------------------------------------
Sub Pivot_SelectionChange(
Set PiVot_select = Pivot.Selectio
if TypeName(PiVot_select) = "PivotDetailRange" then ' Click on I
msgbox PiVot_select.Selection '----> msgbox only for code testing, give erro
end i
End Su

 

[Effie Ram]

I've solved my issue.

 

[Alvin Bruney [MVP]]

it's a good idea to post your solution to help others

 

[Effie Ram]

Well, i see what you mean...
But on the other hand, as far as i can see, MS MUST supply this kind of data, aspacialy in our case for a very poor documented OWC.
I fail to understand way we (developers) must struggle for nearly every line of code that we are doing,
Not to mention the consideration that we must do in light of the different versions on OWC, and the competebility issues.

 

[Alvin Bruney [MVP]]

I understand but you aren't helping Microsoft. You are helping other's like
you who can't get their questions answered. Sure, the lack of documentation
was the cause but it doesn't, in the present, help others. The focus of
newsgroups is to help others.

--
Regards,
Alvin Bruney [ASP.NET MVP]
Got tidbits? Get it here...
http://tinyurl.com/3he3b

Well, i see what you mean...
But on the other hand, as far as i can see, MS MUST supply this kind of

data, aspacialy in our case for a very poor documented OWC.

I fail to understand way we (developers) must struggle for nearly every

line of code that we are doing,

Not to mention the consideration that we must do in light of the different

versions on OWC, and the competebility issues.

 

[kiln]

Well, i see what you mean...
But on the other hand, as far as i can see, MS MUST supply this kind of data, aspacialy in our case for a very poor documented OWC.
I fail to understand way we (developers) must struggle for nearly every line of code that we are doing,
Not to mention the consideration that we must do in light of the different versions on OWC, and the competebility issues.

Yep you're right. It's not your responsiblity to help Microsoft. They
are going a simply terrible job of supporting the OWC (even more so than
the other products of theirs that I'm involved with). However if you
share your discovery with your peer devs here, you at least have a
chance of helping them.