Generate a Word doc from Excel Kesbutler 12/23/2008 3:34:01 PM 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?

Re: Generate a Word doc from Excel "Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> 12/23/2008 7:32:46 PM 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 "Kesbutler" <Kesbutler[ at ]discussions.microsoft.com> wrote in message news:D012F2C0-565D-4A8D-B11C-5B815804E947[ at ]microsoft.com... [Quoted Text] >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? >

RE: Generate a Word doc from Excel Lori 12/23/2008 8:34:01 PM 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 "Kesbutler" wrote: [Quoted Text] > 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? >