hello all

Please bear with me as this may not even be the correct place to post.
Have a word document report/(Sample attached)


Existing macro already present to create labels
Now have embedded excel sheet to populate a table
This sheet has over 350 rows which I have currently placed in an adjacent sheet within the embedded.
Based on the value selected here the other columns in the embedded sheet (value 1... value9) will be filled from the drop down list (possibly via VLOOKUP).
However my gut feeling is that there is a better option - possibly via XML files/codes.
I appreciate that it is not right to have the code embedded in each report as there will be many hundreds of these reports created in working week but I could not get a remote/external workbook to work
I am adept enough at all things Excel/Word but am now starting to swim out of my depth.

I would appreciate any help in this matter.

Regards

Nisio

Attached Files

sample file 150128.doc (119.5 KB, 10 views)

I have actually managed to sort it with some major google searching and help from previous posts here - big thank you to Graham Mayor ... Now need to notch it up with Vlookup within VBA word for the selected Excel record/row. Any pointers again greatly appreciated...

Regards

Nisio

If you're trying to conditionally-populate a Word table, you'd do better to use an ordinary table, rather than an embedded Excel worksheet, and simply retrieve the data from Excel. Depending on what you're after, that might be done via a macro or via mailmerge.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]