Get data from Excel without having to insert an Excel Worksheet!

[Leo]

Hi Everyone,

I am not sure how to do this but I will like to be able to obtain
information from Excel without having to cut and paste.

For example: I typically have all the information that I need in
spreadsheets and once I am done with the spreasheet I need to use some
information from different cells in the spreadsheet in order to populate
fields in a Word document. Can this be done without coding in Visual Basic.
Or such application does not exists? Perhaps I might be able to do this with
access but I am not sure.

Any help and/or suggestions will be greatly appreciated.

Thank you.

Leo

 

[Doug Robbins - Word MVP on news.microsoft.com]

It cannot be done without coding in Visual Basic (whether the data is in
Access or Excel)

See the article "Access a database and insert into a Word document the data
that you find there" at:

http://www.word.mvps.org/FAQs/InterDev/GetDataFromDB.htm

and "Control Excel from Word" at:

http://www.word.mvps.org/FAQs/InterDev/ControlXLFromWord.htm



--
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, originally posted via msnews.microsoft.com