Opening SharePoint lists with Excel Macro
 

I want to write a macro to open a SharePoint List and copy the data into the
excel file where it will be combined with other SharePoint data from other
lists. The path to the list is (forgetting the xxx.yyy.zzz portion):
http://xxx.yyy.zzz/Disciplines/Produ...A/default.aspx

when I select the datasheet view (to copy from) it has this path
http://xxx.yyy.zzz/Disciplines/Produ...et%20View.aspx

Normally I would open another excel file (such as test.xls) and use this
command, but the equivilent to open these SharePoint lists is what I need
help with:
Workbooks.Open Filename:= _
//xxx.yyy.zzz/disciplines/test.xls

Thank you

--
Thanx