Treeview Control populating

[Joe O.]

I am trying to populate a treeview control in excel using a
SQL Server record set and not getting it to work.

Any help or direction would be appreciated.

 

[Juan Pablo González]

Can you post the code that is not working, and explain why is it not working
?

 

[onedaywhen]

I assume we're talking about a hierarchical recordset created using
the MSDataShape provider? There's an example for a treeview control on
MSDN:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dninvb00/html/ivb00a1.asp

However, I recommend you consider another control, such as MSHFlexGrid
(hierarchical flexgrid control), at which you can point your
hierarchical recordset as a datasource i.e. don't need to create the
nodes yourself.