You do know that you can open a sharepoint list into Excel. One option under
Actions is EXPORT TO SPREADSHEET. You can edit the list (although I think
some fields are not editable) and once done, go to Data - List - Syncronize
List and it's back on Sharepoint.
--
HTH,
Barb Reinhardt




" wrote:

The are three parts to this. Using VBA I would like to:
1. Capture items in a sharepoint list and put them into an array for use on
an Excel worksheet
2. Capture the items in from a row in a sharepoint list and 3. manipulate
this data in Excel and put it back into the row into the sharepoint list again

PS I'm using Excel 2003 but can easily use 2007. Likewise the SP is 2003
MOSS but is about to be upgraded to 2007

Many thanks

James