ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Can I embed a WORD document in an EXCEL spreadsheet cell (https://www.excelbanter.com/excel-programming/331692-can-i-embed-word-document-excel-spreadsheet-cell.html)

singerjim

Can I embed a WORD document in an EXCEL spreadsheet cell
 
I want to set up a spreadsheet in which I can click on a cell and open up a
separate word document for each cell. Can it be done

William Benson

Can I embed a WORD document in an EXCEL spreadsheet cell
 
Yes, if the path to the files is continuously available, you can insert a
hyperlink into each cell. Rt-click the cell and select insert hyperlink, it
is pretty straightforward.

If the paths are not (or will not be) available, you need to embed the word
docs. Choose Object from the Insert menu, click "Create From File" tab, and
select the file. Check the "Display As Icon" check box. Be sure to later
resize it and rt-click it to "Format object. The properties tab has "move
and size with cells", this may be helpful.

Bill
"singerjim" wrote in message
...
I want to set up a spreadsheet in which I can click on a cell and open up

a
separate word document for each cell. Can it be done





All times are GMT +1. The time now is 09:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com