Thread: organize files
View Single Post
 
Old 05-01-2012, 03:41 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote