Hi userman,



IMHO, the simplest and most effective solution is to not put any of the data into the workbook but, instead, keep the data for each product in the separate files and simply have hyperlinks in the workbook to open those files. Amongst other things, this is must easier for you to maintain - if the PDF or the specifications for a given product change, simply replace the files with new ones having the same names.

If that is not suitable, you will need to provide a sample workbook with some embedded PDFs and specifications, plus some of their files, so I can see how you want the data processed.

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