Import Excel file into Word doc?

Subject: Import Excel file into Word doc?
From: "Hart, Geoff" <Geoff-H -at- MTL -dot- FERIC -dot- CA>
To: "TECHWR-L" <techwr-l -at- lists -dot- raycomm -dot- com>
Date: Tue, 26 Jun 2001 15:46:12 -0400

Linda Harrison wonders: <<what's the best way to import an Excel file into a
Word doc? it's not to keep the Excel file active, but to capture it as a
snapshot. i can't imagine Word has the capability to import an active Excel
file and keep
the Excel file active.>>

"Best" depends on how you're planning to use the file. If you'll only be
using it on your own computer, or within a group of people who all have the
full Office suite and access to the same network directories, it's easy to
embed the spreadsheet: simply open Word's Insert menu, select "Object", then
browse your way to the Excel file. The problem with this approach is that it
travels poorly between computers (in my limited experience, the links have a
nasty tendency to break), and it greatly complicates moving the Word file
into another application (e.g., into HTML, or into PageMaker). If you don't
mind breaking the link with the spreadsheet, simply export the desired range
of cells as a "tab delimited ASCII" file, then import that into Word
(Insert-->File). Once it's in Word, select the imported text, open the Table
menu, and select "Convert to table". Voila!

--Geoff Hart, FERIC, Pointe-Claire, Quebec
geoff-h -at- mtl -dot- feric -dot- ca
"User's advocate" online monthly at

Tarzan's rule of data processing: Never let go of
one vine until you have a solid hold of the next.--Anon.


*** Deva(tm) Tools for Dreamweaver and Deva(tm) Search ***
Build Contents, Indexes, and Search for Web Sites and Help Systems
Available now at or info -at- devahelp -dot- com

Sponsored by Cub Lea, specialist in low-cost outsourced development
and documentation. Overload and time-sensitive jobs at exceptional
rates. Unique free gifts for all visitors to

You are currently subscribed to techwr-l as: archive -at- raycomm -dot- com
To unsubscribe send a blank email to leave-techwr-l-obscured -at- lists -dot- raycomm -dot- com
Send administrative questions to ejray -at- raycomm -dot- com -dot- Visit for more resources and info.

Previous by Author: Software question? (one tool to rule them all, one tool to find t hem...)
Next by Author: Tools: Good source of technical support
Previous by Thread: Re: import Excel file into Word doc?
Next by Thread: RE: import Excel file into Word doc?

What this post helpful? Share it with friends and colleagues:

Sponsored Ads