VBA Code for importing cell from Word to excel

$30-250 USD

Completed

Posted

almost 11 years ago

$30-250 USD

Paid on delivery

The project consist of copying the content from one cell in a WORD table into an excel spreadsheet. The location as well as the number of tables is variable among the documents but the "tittle" of the cell is constant-"External References". I found a code online that will copy all the tables of a document and paste them into an excel sheet- see excel attached. I need to modify it so it does the following: - Extract data from all the documents within a folder. I have to process 6000 word documents. - Copies only the data within the cell that starts with "External References". - Paste the name of the document in an adjacent cell to what is being imported.- so it is easier to correct documents. - Each cell being copied needs to be pasted one after another in rows. In case of any questions, please feel free ask.

Excel

Visual Basic

Word

Project ID: 4601066

About the project

10 proposals

Remote project

Active 11 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@deepbluetech

Hi, I have done some VBA projects involving Word & Excel and can take on the job. Kindly provide further details. Regards, Arul

$100 USD in 3 days

5.0

(84 reviews)

5.2

10 freelancers are bidding on average $117 USD for this job

@Teloquence

Consider it done. Check your PM for my bid details.

$98 USD in 3 days

5.0

(65 reviews)

5.5

@adim

More than 10 years experience in Excel and VBA.

$153 USD in 3 days

5.0

(13 reviews)

4.4

@microk

Expert here.. Please check PM..

$35 USD in 3 days

4.9

(20 reviews)

4.3

@srdas2012

Please see our Portfolio already done similar projects

$173 USD in 7 days

5.0

(11 reviews)

3.4

@kamtrivedi

20+ Yrs of experience developing IT Solutions using Microsoft Technologies. Excel-VBA, Word-VBA expert here. Please contact.

$175 USD in 3 days

5.0

(1 review)

0.6

@TheGDs

Hi, We are expert in Visual Basic for Applications and MS Office Automation Scripts. Upon awarding we will prove to be worthy of your confidence on us. Extraction of data from MS Word to MS Excel will exactly as described by your. We will try our best to give you the efficient and bug free code. Best Regards, GD

$100 USD in 1 day

0.0

(0 reviews)

0.0

@sweetiehottie

I'm good in excel/spreadsheet try me for $100

$155 USD in 3 days

0.0

(0 reviews)

0.0

@malhotragundeep

Hi , Our employees have extensive industrial experience in automating Microsoft products We are specialized in creating o Time management utilities, o Inventory systems, o Gantt charts, o Forecasting model, o Web automation, o Creating Add-in, o Automating MI reports, o Dashboards etc. We are proficient in creating these using dynamic formulas, tables, queries, reports, Charts, Pivot tables, Macros and VBA. We have an Experience of more than 7 years in Microsoft Access, Excel, VBA, PowerPoint, Think cell and other Microsoft Office products. And we have a dedicated testing team with same experience so that our product goes off without any bug and with best quality. We focus on quality and excellence in our work. Regards, Gundeep Malhotra

$133 USD in 1 day