Thread: Loading an xml
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams Tim Williams is offline
external usenet poster
 
Posts: 1,588
Default Loading an xml

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

--
Tim Williams
Palo Alto, CA


"Mike Archer" wrote in message ...
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