View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
teepee[_3_] teepee[_3_] is offline
external usenet poster
 
Posts: 107
Default 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