Displaying Tree Structure in List Box

[King]

Hi,

I am creating a hyperion essbase VB application in Excel. I am using VB
APIs provided by hyperion. I have a tree structure, and i want to
display that tree in the parent child relations in list box. I mean, i
want to display that tree in the same way the windows explorer is
allowing us to browse through the file directories in the left frame (
by showing list of folders and '+' sign is added to the folders that
have another directories below it. If you click on the '+' sign, it
will show you directories below it. In the same way, I have a parent,
and below it there are some children, and those children are again
parent of another children and so on..). my question is, is it possible
to display it in list box, or any other component? and if yes, how?

TIA

King.

 

[Tom Ogilvy]

You want to use a Treeview Control. this is distributed with Office (unless
you have the developer edition). I believe it is distributed with VB6 if
you have that.

 

[Jim Thomlinson]

I have one developed if you want a copy I could send it to you...

 

[Jim Thomlinson]

I have one already built. I will send you a copy...

 

[King]

I got your mail Jim. That was the logic I was looking for. It's great
help from you.

Thanks a lot.

 

[Jim Thomlinson]

The two modules in there are my standard Essbase functions. You can plug them
into any spreadsheet and use the methods to do a number of different
functions. I stripped the errorhandling out but otherwise that is how I
retrieve and send and... The only thing you need to change are the constants
at the top of the Functions module...