TechWhirl (TECHWR-L) is a resource for technical writing and technical communications professionals of all experience levels and in all industries to share their experiences and acquire information.
For two decades, technical communicators have turned to TechWhirl to ask and answer questions about the always-changing world of technical communications, such as tools, skills, career paths, methodologies, and emerging industries. The TechWhirl Archives and magazine, created for, by and about technical writers, offer a wealth of knowledge to everyone with an interest in any aspect of technical communications.
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
www.raycomm.com/techwhirl/usersadvocate.html
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 http://www.devahelp.com 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 http://www.cublea.com
---
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 http://www.raycomm.com/techwhirl/ for more resources and info.
