View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kesbutler Kesbutler is offline
external usenet poster
 
Posts: 30
Default Word doc from Excel using a macro?

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 (maybe
some checkmark or something) 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?