VBA Macro to extract Word document contents to CSV

This project received 16 bids from talented freelancers with an average bid price of $115 USD.

Get free quotes for a project like this
Project Budget
$30 - $250 USD
Total Bids
Project Description

I need a Word or Excel VBA macro that iterates over a folder of consistently-formatted Word files (.doc), extracts the text of individual articles from the Word file, and appends them as rows in a CSV file.

Each Word document contains ~200 distinct articles. Each doc has a table of contents that can be used/ignored as needed.

The resulting CSV has fields for the date of the original .doc file (i.e., its filename), and the article category, six-digit ID number, article title, article text, and article source.

The attached examples should help you better understand what I'm talking about.

This is a simple project, so please be specific to it in your response. I don't need a list of websites you've built, programming languages you know, etc. Tell me why you're the right person to do this and we'll move forward.

I may have additional VBA work going forward but right now I just need this one macro.

Thanks for your interest.

Skills Required

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online