Advertisement

10.15.2007 at 03:51PM PDT, ID: 22894923 | Points: 250
[x]
Attachment Details

MSXML LOAD

Asked by vbandaru in Microsoft Visual Interdev, Microsoft Office Suite, Microsoft Excel Spreadsheet Software

Tags: vba, msxml

I am loading an XML document through a VBA Macro over the network drive. The Size of the document is about 100 MB.
For performance reasons, I was planning on have a script that would ZIp the file and copy it to the local folder and then unzip it and the load it using the MSXML load Method.  Everything works well. The Size  of the zip file comes down to 3 MB and then i unzip it back to it's orginal size.

One thing that puzzles me is that the time take to load the xml document through the Load Method is same if done over a network or from the local c:\ drive.

Does this make sense?Start Free Trial
[+][-]11.08.2007 at 11:13PM PST, ID: 20247922

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628