H
houston
Dear everyone,
My company's sales force is using a workbook which they periodically
synch with backend system
How it works is the workbook exports the workbook into XML, call a
method in backend web service and passes the XML string over. A fresh
new XML string is returned after processing. Workbook loads in the XML
using ThisWorkbook.XmlMaps("Changed").ImportXml method.
If the XML is big- 16000 records in sheet1 and 5000 records in sheet2,
the ImportXml takes 40 minutes to complete the import, causing a long
wait for time to user.
Is there anyway to make ImportXml run faster ?
regards
Houston Shum
My company's sales force is using a workbook which they periodically
synch with backend system
How it works is the workbook exports the workbook into XML, call a
method in backend web service and passes the XML string over. A fresh
new XML string is returned after processing. Workbook loads in the XML
using ThisWorkbook.XmlMaps("Changed").ImportXml method.
If the XML is big- 16000 records in sheet1 and 5000 records in sheet2,
the ImportXml takes 40 minutes to complete the import, causing a long
wait for time to user.
Is there anyway to make ImportXml run faster ?
regards
Houston Shum