Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
web refresh question
Data source is an online XML stream mapped onto Excel
Instead of using the command ActiveWorkbook.XmlMaps("java_Map").DataBinding.Ref resh Is there a VBA way of refreshing just the required mapped cells Sheets("Sheet1") Range("Y3:AA53") in order to speed the process up? It seems to hang the system for about half a second to refresh the whole thing. Many thanks |
#2
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
web refresh question
I don't think it would save a significant amount of time. You still have to
open the XML file and parse through the XML file to find the range of data you are looking for. The time it takes depends on the size XML file, not the amount of data in the Excel going into the spreadsheet. "teepee" wrote: Data source is an online XML stream mapped onto Excel Instead of using the command ActiveWorkbook.XmlMaps("java_Map").DataBinding.Ref resh Is there a VBA way of refreshing just the required mapped cells Sheets("Sheet1") Range("Y3:AA53") in order to speed the process up? It seems to hang the system for about half a second to refresh the whole thing. Many thanks |
#3
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
web refresh question
"Joel" wrote in message ... I don't think it would save a significant amount of time. You still have to open the XML file and parse through the XML file to find the range of data you are looking for. The time it takes depends on the size XML file, not the amount of data in the Excel going into the spreadsheet. Guess that's probably true. Thanks for the response |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
web refresh question | Excel Discussion (Misc queries) | |||
query after refresh question | Excel Programming | |||
Automatic Refresh Question | Excel Programming | |||
Refresh Code Question | Excel Programming | |||
refresh data vba question | Excel Programming |