Olli2005
11-20-2005, 11:06 AM
Hello everybody,
hope I target the right forum with this question, it is about the best way to get data from a sharepoint list into some fields in Word (all in Office 2003).
I need to select a customer from a list , in Word. The list of customers has to be filled from a list in SharePoint. After a customer has been selected, the address fields should be filled with the respective data, again from the SharePoint list.
I could not find a proper way to access the SharePoint list using VBA, but from what i collected so far it should be possible (only through Excel?). I tried using Smart Documents, shared Workspaces etc., but failed.
At least Microsoft claims, that all Office (2003) apps can talk happyly to each other, but how exactly?
Any help would be highly appreciated, especially some lines of code as a sample starting point. If anyone has an idea how it can be done by using a webservice or other ways, i would be happy too.
Needless to say, that I have to finish this for our customer by end of Nov.
Thanky to all of you!!!
Regards,
Olli
hope I target the right forum with this question, it is about the best way to get data from a sharepoint list into some fields in Word (all in Office 2003).
I need to select a customer from a list , in Word. The list of customers has to be filled from a list in SharePoint. After a customer has been selected, the address fields should be filled with the respective data, again from the SharePoint list.
I could not find a proper way to access the SharePoint list using VBA, but from what i collected so far it should be possible (only through Excel?). I tried using Smart Documents, shared Workspaces etc., but failed.
At least Microsoft claims, that all Office (2003) apps can talk happyly to each other, but how exactly?
Any help would be highly appreciated, especially some lines of code as a sample starting point. If anyone has an idea how it can be done by using a webservice or other ways, i would be happy too.
Needless to say, that I have to finish this for our customer by end of Nov.
Thanky to all of you!!!
Regards,
Olli