Linking excel and word?

[EM]

Hi You there!

Having a problem:

I have an excel workbook and need to copy information from some cells into
another cells in word document which has multiple pages and multiple
tables.... Can it even be done? And if so, how?

Any help would be appreciated..

-erin-

 

[Cindy M -WordMVP-]

Hi Em,

I have an excel workbook and need to copy information from some cells into
another cells in word document which has multiple pages and multiple
tables.... Can it even be done? And if so, how?

Probably/possibly. You don't really provide enough information. How? Well,
by copying and pasting, certainly (human intervention). Programmatically,
that would depend a lot on the version of the software, how the spreadsheet
is setup, and how the Word doc should turn out. Automation of Word, picking
the data out of the worksheet using ADO or DAO would certainly be one
possibility applicable across most Office versions.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail