merge word with excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tjarvas - 04 Mar 2004 23:21 GMT

I have a basic question. Can you merge a specific cell from
spreadsheet in excel into word? If so how would you go about doin
that.

Thanks

Reply to this Message

Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 05 Mar 2004 09:12 GMT

For one cell, copy it to the clip board then in Word, select Paste Special
from the Edit menu and check the Paste Link box. You will probably want to
paste it as Formatted Text (RTF).

Signature

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

>
> I have a basic question. Can you merge a specific cell from a
[quoted text clipped - 5 lines]
> ------------------------------------------------
> ~~ Message posted from http://www.WordForums.com/

Reply to this Message

Jon Stangroome - 06 Mar 2004 15:46 GMT

Open Excel and read the cell into a variable prior to page placement using a bookmar
Set ExcelApp = CreateObject("Excel.Application"
ExcelApp.Workbooks.Open FileName:="C:\LFBills\Disb.xls
ExcelApp.Visible = Tru
ExcelApp.Sheets("Data").Selec
ExcelApp.Range("N3").Selec
ExcelApp.Selection = CurrentClien

Reply to this Message