App to create word document from excel data

IN PROGRESS
Bids
17
Avg Bid (USD)
$144
Project Budget (USD)
$30 - $250

Project Description:
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 #,##0.00
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 required:
Visual Basic, Word
Additional Files: clientledger-sourcedata.xlsx LedgerReport.docx
Hire jpresto
Project posted by:
jpresto United States
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 200
in 3 days
$ 111
in 1 days
$ 105
in 3 days
$ 100
in 3 days
Hire KellogITSolution
$ 111
in 3 days
$ 200
in 3 days
Hire SouthernStars
$ 189
in 8 days
$ 101
in 8 days
$ 100
in 3 days
$ 111
in 3 days