Linking data from Excel to Word 2007

[jwcev]

I am attempting to create a word document that will lookup the data from an
excel spreadsheet and insert several of the fields into the document. There
would be 2 such sections in the document looking up data from different
spreadsheets. Ideally, there would be a drop down list in word that would
then populate the remaining fields. I have been having trouble finding a way
to do this.

 

[Doug Robbins - Word MVP]

For ideas, see http://gregmaxey.mvps.org/Populate_UserForm_ListBox.htm

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

 

[Josh Viessman]

Thanks Doug,

This seems to be what I am looking for. However, as a VBA newbie, I'm
having some trouble adapting the listed code. I am curently stuck at
an OpenRecordset line. The code examples have a 'mySSRange' option
listed, but I don't know how to specifically adjust that. I think I
just need to define the range of cells I want to use from my
spreadsheet, but don't know how to define it. I was searching for a
decent listing of syntax and parameters for VBA that might help out.

Josh

 

[Doug Robbins - Word MVP]

You need to create the Name for the Range in Excel itself (Not by using VBA
Code). The easiest way to do this is to add the Name Manager to the QAT in
Excel.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
Thanks Doug,

This seems to be what I am looking for. However, as a VBA newbie, I'm
having some trouble adapting the listed code. I am curently stuck at
an OpenRecordset line. The code examples have a 'mySSRange' option
listed, but I don't know how to specifically adjust that. I think I
just need to define the range of cells I want to use from my
spreadsheet, but don't know how to define it. I was searching for a
decent listing of syntax and parameters for VBA that might help out.

Josh