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

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

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