Excel Values in Word listbox - resolved

[Scott_MacKenzie]

OK. So, there are a few ways to do this - Word Help says via a DDE connection. I have scoured the forums here to see how I can possibly do it, including Dim'ing new objects and applications... but I am at a loss.

This is the plan;

1 x Excel file that has two columns. Column A has the title of a document. Column B has the server path to that document. There will be about 30 documents - therefore, 30 lines in the excel file (for now, called "Extras.xls"). So - Extras.xls could have this as the first line;
R1C1: File1 R1C2: C:\File1.doc

1 x Open, blank word document. Run a macro that shows a form. On that form I simply want a listbox, listing the values in Extras.xls - Column A.

When you select one of the values in the listbox, and click on a button, I would like word to open the particular word document as listed in Column B of the excel sheet, Copy the text in that document, close that document, and then paste it into the Blank document that you started with. Then the user can choose another record in the listbox, and repeat the process for that record...

So - a new document is created, made up of lots of other smaller documents, based on which records the user chooses from within that listbox. Does this make sense?

Ideas, or sample code anyone?

Scott.