Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to make ImportXML run faster
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I make Excel run faster? | Excel Programming | |||
How can make Save faster | Excel Programming | |||
can you make this faster? | Excel Programming | |||
How Can I make excel go faster | Excel Programming | |||
make my VBA program faster | Excel Programming |