Loading an xml

[Mike Archer]

Hello - I have a userform that loads an xml file with the initiallization
event then populates a listbox using an xpath query. I need to populate up
to 6 listboxes with filters based on what the user selected from the previous
listbox. So I am loading the xml with click events, and it is a very large
file. Is there a way to load it when the form initializes and keep it loaded
until the form is unloaded?
--
Thanks,
Mike

[Tim Williams]

Create a global variable to hold the document and it should be maintained between selections.

--
Tim Williams
Palo Alto, CA


"Mike Archer" <MikeArcher@discussions.microsoft.com> wrote in message news:F4144B88-9DE3-4E55-88A5-61A454799C4A@microsoft.com...
> Hello - I have a userform that loads an xml file with the initiallization
> event then populates a listbox using an xpath query. I need to populate up
> to 6 listboxes with filters based on what the user selected from the previous
> listbox. So I am loading the xml with click events, and it is a very large
> file. Is there a way to load it when the form initializes and keep it loaded
> until the form is unloaded?
> --
> Thanks,
> Mike

[Mike Archer]

Okay.. Because it so big, do I need to worry about dumping when the userform
is unloaded?
--
Thanks,
Mike


"Tim Williams" wrote:

> Create a global variable to hold the document and it should be maintained between selections.
>
> --
> Tim Williams
> Palo Alto, CA
>
>
> "Mike Archer" <MikeArcher@discussions.microsoft.com> wrote in message news:F4144B88-9DE3-4E55-88A5-61A454799C4A@microsoft.com...
> > Hello - I have a userform that loads an xml file with the initiallization
> > event then populates a listbox using an xpath query. I need to populate up
> > to 6 listboxes with filters based on what the user selected from the previous
> > listbox. So I am loading the xml with click events, and it is a very large
> > file. Is there a way to load it when the form initializes and keep it loaded
> > until the form is unloaded?
> > --
> > Thanks,
> > Mike
>
>
>

[Tim Williams]

If the form is unloaded then it should be dumped automatically.
How big is it?

Tim

"Mike Archer" <MikeArcher@discussions.microsoft.com> wrote in message news:29733CC8-58F7-4D82-83F1-2C5FF1EC9935@microsoft.com...
> Okay.. Because it so big, do I need to worry about dumping when the userform
> is unloaded?
> --
> Thanks,
> Mike
>
>
> "Tim Williams" wrote:
>
>> Create a global variable to hold the document and it should be maintained between selections.
>>
>> --
>> Tim Williams
>> Palo Alto, CA
>>
>>
>> "Mike Archer" <MikeArcher@discussions.microsoft.com> wrote in message
>> news:F4144B88-9DE3-4E55-88A5-61A454799C4A@microsoft.com...
>> > Hello - I have a userform that loads an xml file with the initiallization
>> > event then populates a listbox using an xpath query. I need to populate up
>> > to 6 listboxes with filters based on what the user selected from the previous
>> > listbox. So I am loading the xml with click events, and it is a very large
>> > file. Is there a way to load it when the form initializes and keep it loaded
>> > until the form is unloaded?
>> > --
>> > Thanks,
>> > Mike
>>
>>
>>