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.
Re: (MS) Linking from a point in an XLS file to a spot in a Word doc?
Subject:Re: (MS) Linking from a point in an XLS file to a spot in a Word doc? From:<neilson -at- windstream -dot- net> To:Emoto <emoto1 -at- gmail -dot- com>, techwr-l -at- lists -dot- techwr-l -dot- com Date:Tue, 23 Feb 2010 16:00:46 -0600
In general when there is a "big spreadsheet" (or worse, a big Access db) the client should be using a genuine db system such as Teradata, Oracle or Sybase, with applications to provide the needed usability.
What happens when someone at the client's office decides to e-mail the pointer to the Word doc to some outside person, and actually e-mails, instead, the entire spreadsheet? That'll be the spreadsheet complete with all the customer and competitor info and everything else that's tucked into it. A proper db system won't allow that kind of action.
IMHO the client needs a db guru in addition to a tech writer. If the client already has a db section in their IT group, those are the people who should be advising what to do.
--Peter Neilson
---- Emoto <emoto1 -at- gmail -dot- com> wrote:
> Hi folks,
>
> A client has a big spreadsheet with macros in it. One of our business
> people wants to make it so that when you click on some spot in the
> spreadsheet, you are taken to a specific spot in a Word doc. If this
> were all in Word, he would have it all in one file and use
> "cross-references".
>
> I told him I wasn't sure if ti could be done, but that I would take a
> look. So far, I have found that I can link to a whole doc and get it
> to open, but not a specific spot in that doc. I tried embedding the
> XLS and then going into it to make a link and found no way to link to
> the Word doc in which it was embedded.
Use Doc-To-Help's XML-based editor, Microsoft Word, or HTML and
produce desktop, Web, or print deliverables. Just write (or import)
and Doc-To-Help does the rest. Free trial: http://www.doctohelp.com
Explore CAREER options and paths related to Technical Writing,
learn to create SOFTWARE REQUIREMENTS documents, and
get tips on FUNCTIONAL SPECIFICATION best practices. Free at: http://www.ModernAnalyst.com
---
You are currently subscribed to TECHWR-L as archive -at- web -dot- techwr-l -dot- com -dot-