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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top