Excel to Word copying macro


What I need is probably really simple but I can’t figure it out.

I have a bunch of tables in excel that I want to copy into word; with the appearance matching how it would look if I did the copy and paste manually.

Each table is on its own worksheet and is a named range (local name... name is same on each sheet), each sheet also contains a named cell (again... local name... same on each sheet) with the title of the table.

I want the macro to paste the tables into word with the table title separating them, captioned as a table in word.

Ie the macro would do the same as if I:

1) insert a caption with the ‘table’ label

2) the append with the title copied from the value of the title cell

3) copy and paste the named range from the worksheet

4) change the table property to be centrally aligned on the page

Rinse and repeat with the data from the next worksheet.

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

See more: vba macro generate report excel word, excel word vba macro example, macro code generate report excel word, excel vba export to word document, copy data from excel to word using macro, excel vba copy range to word document, import data from excel into word automatically using vba, excel vba open word document and paste, excel vba open word document and copy, vba code to copy from excel and paste in word, macro to export data from excel to word, word forms macro excel access, vba excel word macro, macro across excel word, top form copying excel word, excel word macro examples, create excel word macro, excel word document macro, excel workbook word vba macro, macro excel word bookmark

About the Employer:
( 2 reviews ) Manchester, United Kingdom

Project ID: #18122184

Awarded to:


Hello, I am Luis from Venezuela and it will be my pleasure to help you with this project. I can do your Excel to Word document according to your requirements. Please contact me by chat and then we could discuss f More

£20 GBP in 1 day
(114 Reviews)

10 freelancers are bidding on average £16 for this job


Feel fee to contact me for Excel to Word copying [login to view URL] me message to discuss further more details .We provide the commments,images,videos,demos and live sessions in order to help the [login to view URL] payment only More

£20 GBP in 1 day
(13 Reviews)

Hi, I have 10+ years of experience in report/process automation using MS Excel with VBA. I read the job description and understand the requirements. We can create bookmarks in the word document, and create a control pa More

£20 GBP in 1 day
(3 Reviews)

Hey, I'm interested in your project. Please send me a message so that we can discuss more. Thank you!

£18 GBP in 1 day
(1 Review)

Hello, My middle name is "macro" :) I do this type of work all day everyday, and have done so for 10+ years. I am confident I can write a macro to copy your excel tables to word and format them as you have laid out More

£20 GBP in 0 days
(5 Reviews)

My name is Esteban, I'm an industrial engineer and Excel/VBA Expert. I'm new freelance,You can see some of my experiences in my profile. I could also help in economic analysis and evaluations, based on regression More

£10 GBP in 1 day
(6 Reviews)

Hello, I have already gone through the details from you. I think it is the best suited for me and you will have got an excellent feedback. I am available from now on. I ensure you i will provide you a better quality w More

£10 GBP in 0 days
(2 Reviews)

Dear Hiring Manager, Wish you a very good day, sir. I’ve carefully gone through the every details of your post. According to your demand and my capabilities, I believe myself to be the most appropriate candidate for More

£10 GBP in 1 day
(0 Reviews)

1day 18$

£18 GBP in 1 day
(0 Reviews)

"Dear Next Employer We will give you the best result by uses my Past Experience and excellent academic skills on your project. You cam chat with me and let's get started, I Am ready to show you some samples of similar More

£10 GBP in 1 day
(0 Reviews)