VBA Macro - Extract .doc/.docx text content as CSV

Completed Posted Mar 24, 2014 Paid on delivery
Completed Paid on delivery

I need a Word or Excel VBA macro that iterates over a folder of consistently-formatted Word files (both .doc and .docx), 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, identified by an ID number and . 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 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.

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

Thanks for your interest.

Excel Visual Basic for Apps Word

Project ID: #5709749

About the project

35 proposals Remote project Active Apr 8, 2014

Awarded to:

maverick44000

Hi Scb. I have been doing VBA macros for a long time and I can write one for you that would iterate the folder and extract the required data from doc and docx files. Kindly discuss the project in detail as it requires More

$190 USD in 3 days
(71 Reviews)
6.7

35 freelancers are bidding on average $140 for this job

Teloquence

Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementation.

$200 USD in 0 days
(328 Reviews)
7.6
seaanddream

Hi, your 5-star excel & vba coding expert is ready to help your project. pls check my profile and feedbacks first to have some idea about the quality of my work... I had many similar excel tasks, all achieved with 5/5 More

$105 USD in 3 days
(284 Reviews)
7.8
zExcel

Hi, I will be happy to help you with this project. . -------------------------------------------------------------------------------

$138 USD in 1 day
(254 Reviews)
7.6
mantislin

Hi sir, I am scraping expert, I have did too many similar projects, please check my feedback then you will know. Can you tell me more details? then I will provide demo data for you. Thanks, Kimi

$230 USD in 5 days
(155 Reviews)
7.0
avinav606lx

Hey There, Thanks for posting the project. Its looks very much feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirements to be on the same page and I can start to get this More

$157 USD in 1 day
(165 Reviews)
6.4
svet63

VBA developer since 1997. Can certainly do. Please note that if you plan to work with the CSVs in Excel you may run into issues. For example, Excel can hold max. 32,767 characters in a cell. But sometimes Excel 2003 ha More

$250 USD in 5 days
(62 Reviews)
6.5
Vasilchenko

Hi Ok. I understand that you have folder with Word files. Your files has same structure. And you need to do CSV files base on Data from doc files. I know how to do this. I need one day for this work. I can do it qui More

$50 USD in 1 day
(65 Reviews)
6.3
dpune

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive More

$200 USD in 10 days
(116 Reviews)
6.2
BDtW

Hello, Thank you for describing the project so nicely and attaching the sample files. I have read your description and took a look at the two files, and I believe I can deliver just what you want in 2 days. If More

$85 USD in 2 days
(32 Reviews)
5.3
MuradMurad

Hi, I have lots of experience with automation with vba and ms products. I'll send you a demo macro working on your example files.

$222 USD in 3 days
(8 Reviews)
5.1
tomislav1975

Hello, please check my reviews and contact me on PM for details. I have done such jobs, and can finish this one very fast. With regards, Tom

$155 USD in 3 days
(35 Reviews)
5.3
Tablassus

Dear Sir This project seems interesting and doable based on my past experience with this type of problem. THE SOLUTION: ============ Consider this job DONE. I have a VBA routine to extract data from word docume More

$88 USD in 0 days
(14 Reviews)
4.8
soikaushik2013

70% will be ___COMPLETED___ within 24 HRS. I've done lot of projects on Word-Excel-VBA. I hope I can deliver you final product within 2 days. Thanks in advance.

$111 USD in 5 days
(18 Reviews)
5.1
jal540

I have extensive VBA experience for Excel/Word and excellent ratings and feedback. Can I assume that the fonts used in the example will be consistent? That is one way to determine where the data starts. Is the More

$138 USD in 7 days
(10 Reviews)
4.3
MuhrizRashid

Hello, I am a VB (6.0 / .NET), VBA and VSTO software developer. I have five years of experience in programming. I rest-assure that I will complete the work on time and deliver you the completed work to your satisfactio More

$200 USD in 10 days
(21 Reviews)
4.4
adim

Hello there, I'm a software engineer with more than 15 years experience in Excel, Access, VBA, VB6, .NET, SQL. I'm waiting for detailed project description. During our contract I will be available via Skype/Gtalk More

$155 USD in 5 days
(9 Reviews)
4.1
Aan12

I can do it quickly, in less than one day. Have experienced with VBA macro. You can checkout my two jobs done. Thanks!

$45 USD in 1 day
(19 Reviews)
4.2
KellogITSolution

Hello I am working with MS-Excel and VBA for the past 14 years and have completed successfully a no. of excel VBA projects through freelancer.com. I am ready to do your work and have gone through your project descri More

$155 USD in 5 days
(5 Reviews)
3.1
TypingMachine

Dear Sir, I'm quite interested by your project. I am programmer with sincere and capable. I have developed many project. Particular, I have rich experience in VBA project. I can provide you the best che More

$105 USD in 3 days
(4 Reviews)
2.6
seanmdale

Hi scb2525, I am a professional consultant with a breadth of experience in Microsoft Office products specialising in data manipulation. I have extensive experience with Excel and MS Word macros. I'm even currently work More

$150 USD in 1 day
(5 Reviews)
3.0