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