VBA get information from SharePoint list

[Sharpefiction]

Hi all,
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
I need some help and I’m struggling to find an existing solution, though I know there must be one out there…
<o> </o>
Within VBA I need to get the data from a SharePoint list and display that data within a spreadsheet. I realise I can do the ‘export to spreadsheet’ function within SharePoint, however I need (prefer) to do it via coding, as ultimately I want to search through the data fields within the list and then if they contain the right details it pulls those details from the list and stores them within excel.
<o> </o>
For example:
<o> </o>
Site:<o></o>
http://examplesites/examplefolder/lists/examplelist/
<o> </o>
Item fields:<o></o>
FirstName
Surname
EmailAddress
<o> </o>
In summary, I need:
<o> </o>
· VBA code to link to a SharePoint list from excel
· VBA code to search for a specific field within that list (e.g. FirstName)
<o> </o>
Again, my apologies if this code exists but I couldn’t seem to find it; hopefully the above request is simple enough to answer.
<o> </o>
Thanks in advance

 

[Sharpefiction]

Dont worry I found all that I needed here: http://support.microsoft.com/kb/930006

The step by step was very good