Excel VBA -Merge excel sheet into Word table
This project was successfully completed by deepbluetech for £70 GBP in 3 days.Get free quotes for a project like this
Project Budget£20 - £250 GBP
Completed In3 days
I am in the process of creating an Excel VBA add-in that merges data into a Word template table (or tables).
The user selects the Word template, then the Word table name and source worksheet for each table they want to include.
I have done VBA merges before, but never into a Word table structure and after a few attempts I have come to the conclusion that I need to hire someone with more Word VBA knowledge than I have.
So far I have the following working good:
Word application object
Word document object
Word table object (number)
Word table name (from table number)
I also have an array or worksheet of source data to fill the merge fields with. The rules are:
1 row in the excel sheet = 1 row in the Word table
excel row 1 headings = Word table merge field names
What I need is for you to provide Word VBA code to make this possible any way you can (hopefully via the MailMerge method).
I have read that this is possible using the Catalog or Directory arguments of the Word MailMerge method. This is where I am lost.
This project has a deadline of about 3-4 days.
Please let me know if you need any more info?
[url removed, login to view]
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online