LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
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




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Complicated ODBC data refresh question. JDNETTC Excel Discussion (Misc queries) 6 January 30th 08 11:36 PM
Create refresh button in worksheet to refresh Pivot Table Data Ron Excel Worksheet Functions 1 October 13th 07 01:20 AM
How can I 'Enable Automatic Refresh' for Query Refresh by default Anand Deshpande Setting up and Configuration of Excel 0 December 10th 06 04:47 AM
Excel Pivot Table Refresh Question David D Excel Discussion (Misc queries) 2 August 25th 05 01:00 PM
Query Refresh-Enable Automatic Refresh Dialogue Box Terri Excel Discussion (Misc queries) 0 May 6th 05 08:21 PM


All times are GMT +1. The time now is 04:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"