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