|
Loading an xml
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 |
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 |
Loading an xml
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" 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 |
Loading an xml
If the form is unloaded then it should be dumped automatically.
How big is it? Tim "Mike Archer" wrote in message ... 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" 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 |
| All times are GMT +1. The time now is 05:32 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com