Archive of Mr Excel Message Board

Back to Links in Excel archive index
Back to archive home

Excel and Word
Posted by Mark O'Donnell on September 04, 2001 8:39 AM
Is there a way of linking a word document to part of an excel spreedsheet? In an ideal world I am wanting to be able to click on Sheet 2 and for it to bring up a word page, rather than excel. Or is this just asking too much from Microsoft?
Thanks
Mark.

Re: Excel and Word
Posted by lenze on September 04, 2001 9:00 AM
This is close to your ideal: In Excel, Choose Insert>Object> and select Word Document. This will embed a word document in you Excel file. When you double click the document, Word will activate and you can edit it. When you click outside, you eill return to Excel. You can also go the other way and embed an Excel sheet in Word.

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.