Re: WORD vs. EXCEL: How to Optimize

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Ed (Ed_Millis_at_NOSPAM.Hotmail.com)
Date: 06/03/04 

Date: Thu, 3 Jun 2004 06:22:49 -0700

If you have large blocks of text that must be formatted a certain way, one
option may be to write these blocks of text in Word docs, and put hyperlinks
to these docs in your workbook. Your code then would simply choose cells
depending on user input; code for these cells would open the hyperlinked
doc, copy the text, and paste it into your letter. This would allow you to
change the text or the formatting of a block of text, even to include
bookmarks to hold values from other cells with formulas.

I would tend to think this would need to be Excel-driven, if that is the
interface your user has open. It allows the user to simply enter data, and
then code can "push" the necessary data into the letter. Or you might
consider a Word template for your letter with an Auto_Open macro that will
read certain cells in your workbook and "make decisions" based on those
values.

HTH
Ed

"Random NumNuts" <ran@hotmail.com> wrote in message
news:uZqvc.74623$og1.45430@fe03.usenetserver.com...
> Hi all...
>
> I have a fairly complex spreadsheet that also incorporates lots of legal
> text. The app allows reps to enter info about prospects, and it computes
> pricing, generates legal documents, and other info. Clearly, EXCEL handles
> the math, but is weak with text.
>
> Depending upon certain inputs, different blocks of text may be used.
>
> Ideal world: utilize the best of both. Question: should I make this a
> WORD_centric document or an EXCEL-centric document, and how to set up the
> links between the two.
>
> Many thanks... /Randy
>

Relevant Pages

  • Re: Automatic Cond Formatting of multiple columns based of values
    ... I wanted to explain that my lookup table starts on cell ... Conditional Formatting for each number listed in col M. ... hence the copying and pasting in the worksheet. ... the cells in a number of columns of the main worksheet, ...
    (microsoft.public.excel.programming)
  • Further Issues
    ... -select unlocked cells ... Protect Cell Formatting ONLY ... I understand how to protect a worksheet, and I know how to "unlock" certain ...
    (microsoft.public.excel.misc)
  • Re: Divide entire column by 100
    ... IF you will NOT be using these values in any further/future calculations, then you can make the value "look" like what you want by simply formatting the entry. ... my first question is why not use standard entries? ... For 227, just type in 227 and, also, remove the format from the cells in that column (change the Currency selection to General in the Formatting Cells dialog). ...
    (microsoft.public.excel.programming)
  • Re: Conditional Formatting Help
    ... There are only either these zero cells, ... "Bob I" wrote: ... for blank and set no formatting. ...
    (microsoft.public.excel.misc)
  • Re: Search and change text color or style only
    ... The problem is that formulas can't be formatted this way and cells that are ... "Dave Peterson" wrote: ... Dim myWords As Variant ... Remember this kind of formatting only works on ...
    (microsoft.public.excel.programming)