Generate a Word doc from Excel

[Kesbutler]

I have an Excel file that contains headings that are used to create a word
doc for a training manual. Is there a way I can either auto populate the
Excel headings into Word or select what headings I need and create a macro
that would generate a word doc to populate with text?

Example:

A B C D
1 Title Heading 1 Heading 2 Heading 3
2 Training Topic A Sub-Topic A Task 1
3 Task 2


I need the word doc to populate the headings automatically or if I can
generate a doc from Excel by using a macro by selecting the headings I need
that would be great. The Excel file contains potentially thousands of topics
but not all will be included in all manuals.

Any ideas?

 

[Doug Robbins - Word MVP]

Have you considered the use of Mail Merge?

How would any system determine which of the thousands of topics should be
included?

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Lori]

Kesbutler~

It's not going to be pretty, but try this.

Paste the Excel sheet into Word as a Table (remember that Word DOES NOT LIKE
huge tables, Autosave is going to take a long time to repage so you may want
to increase the time or turn it off.) And the more pages the table runs
across the longer it's going to take to repaginate the table. Save you work
after each step, and yes since you'll have a lot of data, it will take some
time. Be patient.

Highlight the First column (Title) and format as Title (really though you
should only have one title, so technically your first column should be
Heading 1. If you're going to use all 9 Headings+ I would suggest labeling
them Sub-Title). Go grab a cup of coffee if your document is as big as you
say it's going to be. Then format the second column as your next heading,
grab another cup of coffee and so on.

Once all the columns have been formatted, select the table and from the menu
bar select Table > Convert Table to Text and make sure you check Paragraphs.
Since you may have a long document, grab a pillow and catch a snooze.

You'll have to manually delete the stuff you don't want. No way around that.

~Lori