Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
XML Refresh Code
This is how part of my code looks for a macro that goes to each shee and refreshes the xml data there. Sheets("1").Select ActiveWorkbook.XmlMaps("10001").DataBinding.Refres h Sheets("2").Select ActiveWorkbook.XmlMaps("10002").DataBinding.Refres h Sheets("3").Select ActiveWorkbook.XmlMaps("10003").DataBinding.Refres h Sheets("4").Select I have not been succesful on trying to either grab the range of sheet and refresh them or tell vba in simple way instead of having to writ the same line of code for times i need it to do this. Any help would be very appreciated -- waylif ----------------------------------------------------------------------- wayliff's Profile: http://www.excelforum.com/member.php...fo&userid=2986 View this thread: http://www.excelforum.com/showthread.php?threadid=50077 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA code to refresh Child Pivot Table | Excel Discussion (Misc queries) | |||
Code To Refresh Query Table | Excel Discussion (Misc queries) | |||
Code to Refresh Pivot Table | Excel Programming | |||
refresh worksheet code | Excel Programming | |||
Code to refresh macro once monthly | Excel Programming |