Completed

VBA Populate word document with excel value

Hi there,

I need help with the following I have a Word template that contains text and placeholders i.e.

" Hello my name is [name], and I'm [age] and I want to be a [job] when I grow up. As I said, I'm [age] and I would like to be a [job] when I grow up, and my name was [name]."

And an excel file that contains with collum A overview of all the placeholders and collum b with the value beloning to the placeholder.

CollumA | CollumB

Placeholder. | Value

[name] James Bond

[age] 16 year

[job] Police agent

The macro needs to do the following steps:

1) Macro needs to have a start button in the excel ribbon.

2) Once pressed, it shows some text like (Macro name, version number and start button)

3) Open word template from difned folder, that contains text with placeholders.

4) Search for placeholder in the word document and replace it with the value for in collum b of the excel.

5) Show message that macro is done.

Please note the macro needs to be written in a loop, so I don't want to write code for every placeholder.

Skills: Data Entry, Excel, Visual Basic, Visual Basic for Apps, Word

See more: vba create word document excel, populate word document excel, excel vba mail merge word document excel macro, excel vba convert word document, create word document excel vba, excel vba create word document graphs, excel vba create word document, excel vba create word document heading, vba import word document excel, sample vba create word document excel, excel vba open word document text, copy word document excel, parse word document excel spreadsheet, word document excel, copying data word document excel document

About the Employer:
( 3 reviews ) Amsterdam, Netherlands

Project ID: #16065625

Awarded to:

aubrey03

I have done this before so I can just edit the macro I created before and give this to you in one day. Feel free to contact me about this.

$30 USD in 1 day
(18 Reviews)
4.7

17 freelancers are bidding on average $31 for this job

bouslimi1979

Hi, I ll code the macro as per description. But I need to check your Word template before. As we need to give a name for each fields so it can be called and filled by the Excel macro. Thanks

$50 USD in 2 days
(193 Reviews)
7.2
schoudhary1553

Greeting, I have understood your VBA Populate word document with excel value task and can do it with your 100% satisfaction. Please ping me for more discussion. I have more than 5 years of experience in Data Ent More

$30 USD in 1 day
(224 Reviews)
7.3
avinav606lx

Hey There, I have done excel->word/pwerpoint/outlook. Thanks for posting the project. Its looks feasible and am Interested to do it. I am an excel/word/outlook VBA automation professional having 7+ years of expe More

$50 USD in 0 days
(151 Reviews)
6.4
bilalmaher053

hi, can you please send me your word file in chat?

$50 USD in 1 day
(94 Reviews)
5.4
VeteranLK

quick question. excel file has records for only one person?

$30 USD in 1 day
(13 Reviews)
3.7
magentapowa

Hello I have read and understood the requirements. I can hep you build this macro. It is a simple find-replace-save as procedure. I can make it behave exactly as you need to. You will click the button and copies of More

$30 USD in 1 day
(22 Reviews)
3.9
jalileng

being an engineer i believe i can do the job in better way.

$30 USD in 3 days
(1 Review)
0.0
amoghastra

For 6 months i have worked as data scientist so i have done some office projects on excel VBA they are easy

$30 USD in 1 day
(0 Reviews)
0.0
hanumanthnaik

I will do this work, because am having good ms word, and ms excel skills to complete this work as early as possible thank you

$25 USD in 1 day
(0 Reviews)
0.0
krishnaagr89

Hi,I have read your requirements and I’m pretty confident that I will be able to get your work done within the given time your requirements conclude.I am very keen to discuss further. You can reach me at any time on on More

$25 USD in 1 day
(1 Review)
0.0
techsoft7

Hi, I have got Rich experience in Joomla, Wordpress, Codeigniter, Cake PHP), .NET, Asp.NET, Vb.NET, HTML 5 etc.& mobile apps Also have very good knowledge of javascript, jQuery Json, API, Prototype Frameworks, and More

$31 USD in 1 day
(0 Reviews)
0.0
prak8

A proposal has not yet been provided

$35 USD in 2 days
(0 Reviews)
0.0
goeljyoti

A proposal has not yet been provided

$15 USD in 3 days
(0 Reviews)
0.0
rajindersingh43

I m expert in excel so fully justice with your work Relevant Skills and Experience Yes I have 5 years experience in MIS

$25 USD in 1 day
(0 Reviews)
0.0
swamiajay31

Hi, I have completed master in computer applications which is MCA in my home country. I am very well aware of .net technologies, so I am fully assure that I can complete this project. Thanks.

$20 USD in 2 days
(0 Reviews)
0.0
deepakyadav1995

A proposal has not yet been provided

$25 USD in 2 days
(0 Reviews)
0.0