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 | |||
Complicated ODBC data refresh question. | Excel Discussion (Misc queries) | |||
Create refresh button in worksheet to refresh Pivot Table Data | Excel Worksheet Functions | |||
How can I 'Enable Automatic Refresh' for Query Refresh by default | Setting up and Configuration of Excel | |||
Excel Pivot Table Refresh Question | Excel Discussion (Misc queries) | |||
Query Refresh-Enable Automatic Refresh Dialogue Box | Excel Discussion (Misc queries) |