merge word with excel

T

tjarvas

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
 
D

Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT

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).

--
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
 
J

Jon Stangroome

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
 
Top