SharePoint list to SharePoint

[jamesp]

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
shapes on a Visio drawing 2. Capture items from a row in a sharepoint list
and 3. manipulate this data in Visio and put it back into the row in the
sharepoint list

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

 

[Al Edlund]

I'm not quite sure on what your real objective is. It sounds like "I want to
manipulate sharepoint services using VBA, and I don't care what platform it
is based on." In any case David Parker did an example of pulling sharepoint
lists into visio. Since it used Visio datarecordsets (v2007 Pro) for the data
linking, it's a one way path and doesn't roundtrip like your asking. IMHO you
might want to first take this on as a DotNet Sharepoint application for the
data operations, and then apply it to a Visio solutions (either as an addin
or winforms w/activex control).

here's David's post

http://bvisual.spaces.live.com/blog/cns!3350D61BC93733A9!552.entry

hth,
al