Completed

VBA DOC/DOCX to Excel

This project was successfully completed by Amzathkhan for $750 USD in 5 days.

Get free quotes for a project like this
Employer working
Completed by:
Project Budget
$750 - $1500 USD
Completed In
5 days
Total Bids
62
Project Description

Project: VBA FROM DOC/DOCX to Excel
From an Excel spreadsheet we want to be able to select a range of DOC/DOCX from a folder (from 1 to 50 documents).
A VBA script will parse the content of the selected documents and insert the content from each document into the Excel spreadsheet.

//Example
[url removed, login to view]
[url removed, login to view]
[url removed, login to view]
[url removed, login to view]

Goes to
[url removed, login to view]

[url removed, login to view] is structured like this
A1: SourceFilename Name of the DOC/DOCX file
B1: Heading First line in the document
C1: Content The content from the document.


//Challenge
The content will be used for a website, so all styling must be removed. BUT if possible we would like to keep the markup of headings (,), bold, italic and underline so we can manage the styling via a css file.
Linebreaks must be kept.
What about tables in the doc - can they keep formatting?

//Platform
Office 2010/Office 2013

//
More functionality will need to be applied later, so if you can make above work you can expect more work from us :)

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