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:Re: import Excel file into Word doc? From:kcronin -at- daleen -dot- com To:"TECHWR-L" <techwr-l -at- lists -dot- raycomm -dot- com> Date:Wed, 27 Jun 2001 10:36:33 -0700
> 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.
As other responses have indicated, Word CAN import active Excel files.
While that is pretty neato, and a rare example of MS's products actually
playing VERY nicely with each other, you may not want this.
For example, you may intend to include only selected cells from your
spreadsheet. If you use this object-oriented way of importing them, your
reader can still activate the ENTIRE spreadsheet, not just the cells you
think you imported. I deal with sending price listings to prospective
customers, and I do not necessarily want them to see all the inner
workings of the spreadsheets we use to calculate our pricing.
So, to give them just the numbers (or a "snapshot" as you call it), I
recommend you use the Edit, Paste Special, Formatted Text (RTF) option.
This creates a regular table in Word, with none of the underlying
technology that your original spreadsheet may use. You'll probably need to
do some rudimentary formatting and tweaking, but you'll be giving the
reader "just the facts, ma'am."
Hope this is helpful!
- Keith Cronin
_____________________________________
"I can write better than anybody who can write faster, and I can write
faster than anybody who can write better."
*** 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.
