Hi 7ajar,
Any particular reason for maintaining the list in Excel, rather than in another Word document (or even a plain text file)?
Whilst retrieving the data from Excel isn't particularly difficult, it adds overheads that can be avoided in the data are in another Word document (or a plain text file).
For an example of reading in a list from another document, see my code at: http://www.vbaexpress.com/forum/showthread.php?t=34992
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Last edited by macropod; 02-26-2011 at 12:49 AM.
Reason: Added link to code for reading list from another document.
|