App to create word document from excel data

Closed

We require vb code to go through an excel spreadsheet and create a word document based on a template.

Operation to be as follows - this can be changed to be easier to code, but shouldn't be overly complex:

User opens word document, is prompted for Excel spreadsheet.

User browses to file and selects

System performs a quick check that file is correct (checks cells A1 and A2 to have correct field names and that A2 has data) then proceeds to populate template with data.

If user saves file, system should perform a save-as to avoid overwriting application/template

The process of creating the word document from the excel sheet is as follows-

Header:

Put cell O2 in location. This is only in the word docuement once, all rows are be identical

Put cell p2 in location This is only in the word docuement once, all rows are be identical

For each row:

Reformat date (column A) from Apr 21/2009 to Apr 21 2009

Put Column B in location

Put column E in location

Put column H in location - format to #,##[url removed, login to view]

Put extra row between each

Total line:

will be the sum of all the items

Minor changes to template should be able to be made without affecting operation. Need the ability to change font, layout slightly - so need the ability to open the file, cancel out of the macro, make changes and save file.

Attached is a word template and sample excel data

Skills: Visual Basic, Word

See more: populate word document excel, reformat data, excel macro to word, excel macro file location, application template excel, create macro in word, word template, excel data sheet, excel -data, data operation, create word template, Create font, create an operation, create a font, app create, app basic excel, populate excel spreadsheet spreadsheet, excel macro row, word macro basic, sample visual basic excel, document check check spreadsheet, sheet excel visual basic, 2013 excel visual basic, cells identical, excel spreadsheet check check

Project ID: #4503522

Awarded to:

koolsidz

VBA Whiz here ;) Please see PMB

$111 USD in 1 day
(39 Reviews)
5.1

16 freelancers are bidding on average $139 for this job

ineedWorkJob

Greetings sir, i am an expert freelancer. for this job and your 100% satisfaction is assured if you allow me to serve, for more info please cheek your message box for this project(Private)

$200 USD in 3 days
(75 Reviews)
5.9
deepbluetech

I can take on the job. Let me know.

$105 USD in 3 days
(72 Reviews)
4.9
HosElectro

Hello. Im an experienced developer for more than 8 years I can help you please read my pmb

$100 USD in 3 days
(11 Reviews)
4.5
KellogITSolution

Hello Me an Ms-Excel Expert working on MS-Excel & VBA for the past 12 years. I am ready to do your work and could start right now. I have already done a no. of successful Excel Projects and can provide u sample copi More

$111 USD in 3 days
(12 Reviews)
4.3
aptecpymefree

We can work in your word document from excel data. I am a leader of the team expert in several tecnologies like PHP, .NET, Oracle, SQL, Movil applications. I have 14 Years of experience in Software development Windows More

$200 USD in 3 days
(6 Reviews)
4.2
SouthernStars

Long experience in Office automation. Please; see profile.

$189 USD in 8 days
(4 Reviews)
4.1
srdas2012

Hi We are Experts in these type of Data Transfer Please see PMB,our Past work & Present works

$101 USD in 8 days
(10 Reviews)
3.3
iScripter

Sir, Allow us to do this Honor. Please see the PMB regards iScripter

$100 USD in 3 days
(6 Reviews)
2.9
omaralieissa

Hi, i can do this in C#, please let me know if you are interested, thanks.

$111 USD in 3 days
(3 Reviews)
2.6
sachinchavanvw

Please check PM

$111 USD in 3 days
(1 Review)
1.9
esadeghi59

I have over 10 years experience in VB & ready to start working.

$210 USD in 2 days
(0 Reviews)
0.0
davoodabbasi81

As an VBA Expert I am ready

$222 USD in 3 days
(0 Reviews)
0.0
Fitzgeraldz

A warm greeting, I have skills in the following languages c, c++, c#, java, vb, aspx, php, lisp, python. I am an expert in the development of platforms and desktop.

$103 USD in 1 day
(1 Review)
0.0
nachemi

Hello, I've been working in projects like this for years. I can do it from Word template, or there are a couple other ways you can explore. Regards.

$166 USD in 5 days
(0 Reviews)
0.0
evanwang

I am a experienced developer and have ever do similar works,please see PM.

$200 USD in 3 days
(0 Reviews)
0.0
sweetoasis

I can finish this soon, please check PMB.

$100 USD in 1 day
(0 Reviews)
0.0