I have a Workbook template spreadsheet which populates data from 2 different workbooks when you enter a number in a cell. on particular cell references a hyperlink file path to a folder where there are word documents named to match the product code.
I want to be able to embed the file into the second page of the spreadsheet to be able to print when the worksheet is printed and am struggling, all I can do is hyperlink the Cell but it just prints like a hyperlink rather than the document contents, I have tried Insert Object but if I save that in the template it will be the same file when a new document is generated and I need the file name to change when the data populates for each new document from template.
I am hoping someone can help it is driving me Bat sshh IT crazy.
I want to be able to embed the file into the second page of the spreadsheet to be able to print when the worksheet is printed and am struggling, all I can do is hyperlink the Cell but it just prints like a hyperlink rather than the document contents, I have tried Insert Object but if I save that in the template it will be the same file when a new document is generated and I need the file name to change when the data populates for each new document from template.
I am hoping someone can help it is driving me Bat sshh IT crazy.
