In excel 2003 I was successful in linking and XML map to a sharepoint list.
The following code was usedto refresh the list within my excel from
sharepoint.

Sub UpdateList()
ActiveWorkbook.XmlMaps("MyList_Map").DataBinding.R efresh
End Sub

Still works great in 2003, fails in 2007.

Any suggestions?
Thanks, - Pat