Hundreds of word docs compiled into Excel Spreadsheet RRS feed

  • Question

  • Can anyone help me with this?

    I'm trying to take hundreds of word docs and compile them into a spread sheet. Each word doc has 4-10 works cited on the first page. Looking like

    The Madison Times, WI, “Insurance Exchanges Will Extend Coverage to Millions,” September 23, 2013, By Freddie Allen

    Each word doc is for a specific date and it's file name is that date. 
    Example "September 19, 2013"

    I just need the spread sheet to list the date that is for the whole document and the publications that are listed in bold and italicized. 

    If this is unclear please let me know. If I'm asking the wrong people, please direct me where to go.

    Sunday, September 29, 2013 2:06 AM

All replies

  • Hello sceneitguitar,

    Note, this forum thread is for Office developers. That is why I would recommend asking such questions on the Microsoft Community forums.

    Saturday, December 14, 2013 5:21 PM
  • I take it you want to do this with a macro?

    From within Word or within Excel?

    Has the text been formatted directly, or using styles?

    Could we assume that the documents are all stored in the same folder?

    Do you want part of a citation, or the entire citation? It's not clear what is "bold and italicized" and how that relates to what needs to be transferred to Excel.

    Does formatting have to be carried over to the result, or just the text?

    Cindy Meister, VSTO/Word MVP, my blog

    Monday, December 16, 2013 4:49 PM