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:John Posada <jposada01 -at- yahoo -dot- com> To:"TECHWR-L" <techwr-l -at- lists -dot- raycomm -dot- com> Date:Wed, 27 Jun 2001 10:59:39 -0700 (PDT)
> 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,
"Neato" has nothing to do with it. I stopped doing "neato" things
(for the sole sake of "neato") a long time ago. OLE linking is a
tremendous time saver when you plan ahead, use it when appropriate,
and keep the bells and whistles to a minimum. I've used it
alot...even used it to create a complete 76+ page manaagement
presenattion from elements of over 30 different documents (Word,
Excel, and PPT). The document was updated on an ongoing basis
(hourly, as part of the document was based on a feed from our network
servers) as the content from the other 30+ documents/files evolved
(it was the closest that I've ever come to sole-source document
creation).
To solve your problem of access, create a named range for only the
cell section you want to include, create a separate spreadsheet with
only that named range imported, then import that worksheet into Word.
They will only see the range you want them to, but it will be updated
from the "master" spreadsheet dynamically.
=====
John Posada, Senior Technical Writer
"How to be happy in life: Never impose your beliefs
on anyone else and never fry bacon in the nude."
-- Anon mailto:john -at- tdandw -dot- com, 732-259-2874
__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/
*** 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.
