Help with a Word Macro or Object Insert

[FFischer]

I need to reference one cell from an Excel 2010 spreadsheet into a 2010 Word document.

The statement should read simply:

The value in the word document is [ ]

Where [ ] equals "C:\Path\File.xlxs\" and Range equals Sheet1 Range ("A1")

Range "A1" will always be a value - never a formula.

Any guidance would be greatly appreciated.

 

[Macropod]

You could copy the Excel cell, then paste into Word, using Paste Special with the 'paste link' option. That option also gives you a number of paste formats to choose from. From now on, any changes to the Excel cell will be reflected in the Word document.

 

[FFischer]

You could copy the Excel cell, then paste into Word, using Paste Special with the 'paste link' option. That option also gives you a number of paste formats to choose from. From now on, any changes to the Excel cell will be reflected in the Word document.

Perfect! Thank you!