Sharpefiction
New Member
- Joined
- Sep 29, 2010
- Messages
- 33
Hi all,
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><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
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><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
