inserting a range from an excel worksheet into Word

[gray78]

I would like to know how to link a range of cells from an excel worksheet which is part of a workbook into a word document.

 

[Lilliabeth]

Select and copy the Excel range.

Click in the Word doc and choose Edit > Paste Special.

Choose Paste Link.

 

[gray78]

Thanks. I wasn't clear though. I want to be able to link a range of cells from a worksheet which is withing a workbook into a Word document.

 

[macropod]

Hi gray78,

With your Excel worksheet and Word document open:
. copy the source range in Excel
. select the destination point in Word
. use Edit|Paste Special, choose the 'paste link' option and whatever paste format you prefer.

Cheers

[MS MVP - Word]

 

[gray78]

macropod,

Thank you. The problem I am running into is that I want to create a macro to do this function. If the clipboard is empty I get an error as follows:

Run-time error '4605':
This method or property is not available because clipboard is empty or not valid.

The portion of the code in question is:

Selection.PasteSpecial link:=True, DataType:=wdPasteOLEObject, Placement:= _
wdInLine, DisplayAsIcon:=False

Any suggestions?

Gray '78

 

[macropod]

Hi gray78,

The simplest solution would be to precede that line with:
"on Error Resume Next"

That should also be sufficient to trap errors that result from trying to paste data from the clipboard that aren't linkable.

Cheers

[MS MVP - Word]