Linking information

[Hinchy]

Does anybody know if it is possible to link information between excel and word. For example can you use excel to create a calculation which gives you a result and then can you get that result to be shown in word automatically without having to copy and paste? Thanks

[Stefan Blom]

You can create an OLE (automation) link as follows: Select the Excel range and copy it. In Word, click Edit | Paste Special. Choose the "Formatted Text (RTF)" format and select "Paste link"; then click OK.

[Hinchy]

Thanks for that. There's just another question. Would you be able to PDF the word document automatically after the special paste has completed?
Thanks

[Stefan Blom]

If you mean that you want to maintain the OLE link in the PDF file, then no. Only the current content will show up in the PDF.

[Hinchy]

No I mean that if I was to change something in excel it would then change it in word and then could word automatically produce a PDF?
Thanks

[macropod]

This would be possible via a macro or, perhaps, via mailmerge. Without knowing more about what you're trying to achieve, though, it would be hard to advise an appropriate solution.