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
|