Insert Word into Excel or vice versa

V

Vim

I have information in an excel spreadsheet that I use to collate data
and then I want to be able to present this data and add to it with
different paragraphs manually.

The end result I am tryin to achieve is:

information from excel

free text paragraphs of word

information from excel


This can be either in excel or in word, I just want to make it work. I
have it set up now in excel so that I have cells to type in, but excel
is hard to manage the paragraphs and formats that I want.
One idea I had was to mail merge from excel to word, but the data is
all over the show so not under normal headings that mail merging relies
on (nor can it be).

Any ideas or help on how to achieve this would be great! :)
 
E

Ed

What do you mean by
the data is
all over the show
Click to expand...

When you say
information from excel
Click to expand...
how is presented in Word - as a table?

Does
different paragraphs manually
Click to expand...
mean you are going to type in several paragraphs at that moment,
or do you have stock paragraphs you are going to pick and choose from
to put into the document?

Without a bit more information, it's hard to give you anything.
Ed
 
V

Vim

Sorry,

The data is all over the show - I mean that although the data is
consistently in the same place each spreadsheet, it is not in an
orderly row by row as I am used to when previously performing a mail
merge. Although I suppose that I could set this up by using the
existing information.

The information in excel - Rather than a table I would prefer to have
the ability to place individual cells in different locations on the
word document. This would allow me to type in word and expand on the
data.

Different paragraphs - mean that I will manually type in information
that is different for every customer, so the information could be brief
or lengthy.

LET ME EXPLAIN MORE:
I am capturing the data in excel in a sales interview as a mortgage
broker. The data is laid out in excel to help me run the interview in
an orderly fashion.
I then want to take the data and use it to present a fax to the lender
to gain loan approval. I need to add to it with explanations etc that
is personal to each customer. The format needs to be presented as if
it were a fax dcocument when printed.

Thanks for any help.
 
E

Ed

Here's my take: unless you're dealing with a dozen or so of these a day, or
you have more than 7 or 8 places you need data from, you are going to work
harder at a macro than with copy and paste. I'd just have both files open
at the same time - type the letter and copy a cell or two as needed to fit
your narrative.

If you really want a macro, here's what I would do:
-- Record a macro that adds a bookmark at the first place you need data -
call it Data1. Put a place holder text in the bookmark, something like
"XXX1". Assign a keystroke to this macro. Then you're going to edit this
macro to work from a counter. If these are the only bookmarks in the doc,
then you can simply use the count of bookmarks, and assign the next bookmark
name to "Data" & Bookmarks.Count + 1. If you have more bookmarks than
these, then you can assign your counter to a DocumentProperty - either
BuiltIn or Custom.
-- Type your letter, and keystroke this macro any time you need data from
the spreadsheet.
-- Create a second macro. Use the BuiltInDialogs to open the Excel file.
The macro will then cycle through the "Data" & counter bookmarks, grabbing
the last number from the bookmark name. Then you can use a SelectCase
statement - "Case 1: get text from objXL.Sheet1("A1"); Case 2: get text from
another cell; etc."

Ed

Type your letter. Where you need data, put a place holder
 
Top