... interaction with Excel ...

[Guest]

I would like to link some lines in my word document to Some cells of an
existing Excel Spreadsheet.

In otherwords:

Excel File: <<< Scrap Tracking.xls >>>

Worksheet: <<< Apr-05 >>>

Cell-1: <<< E2 >>> (Text = April-05)

Cell-2: <<< C100 >>> (Text = Monthly Total)

Cell-3: <<< D100 >>> (Text = $3,879.09)

I would like a Sentence in my Word Document to read:

.... During "April-05" the "Monthly Total" Scrap Value was "$3,879.09" ...

Is there a way to do that?

Thanks,
Darrell

 

[Doug Robbins]

Edit>Paste Special>Paste as Link, most probably selecting the unformatted
text option.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Guest]

Doug:

I was looking for a paste Special Command, I don't know how I overlooked it.

TY
Darrell

PS

I went to school with a Doug Robbins, we Graduated in 1974. Is that your
vintage?