
Vba macro to copy data from Excel and paste in Word
- or -
Post a project like this1694
€30(approx. $36)
- Posted:
- Proposals: 9
- Remote
- #3112841
- Awarded
WEBSITE DEVELOPMENT & DESIGN ! WORDPRESS ! JAVA ! PHP ! JAVASCRIPT ! GRAPHIC DESIGN | VIDEO | EXCEL VBA & MACRO EXPERT

WordPress Expert | Web & App Developer | SEO Specialist | Content Writer | Blockchain | Python | OpenAI | Machine Learning

TOP PRO - Excel, Word, PowerPoint, VBA, Google Sheet, Outlook, Access, Database, Scripting

14494332561066193247503410731510052557369373078512644635102283





Description
Experience Level: Entry
Hi, I need a simple macro in Vba to copy data from Excel and paste in Word. I use office 2007.
I have a file in Excel that contains tables. Every time the number of tables in the Excel file is different. Every time the size of the table (number of rows and columns) is different. In the same Excel file, tables are different.
I want the macro:
1. Copies the first table
2. Paste it in the opened word file
3. Inserts a page break and two paragraph
4. Copies the second table and repeat steps 2 and 3
5. ...
6. Stops when there are no more tables in Excel
I attach the Excel file from which to take tables, and the Word file that I want as result (the format of the Word file is already done, non need to format it).
Thanks
Arnaldo
I have a file in Excel that contains tables. Every time the number of tables in the Excel file is different. Every time the size of the table (number of rows and columns) is different. In the same Excel file, tables are different.
I want the macro:
1. Copies the first table
2. Paste it in the opened word file
3. Inserts a page break and two paragraph
4. Copies the second table and repeat steps 2 and 3
5. ...
6. Stops when there are no more tables in Excel
I attach the Excel file from which to take tables, and the Word file that I want as result (the format of the Word file is already done, non need to format it).
Thanks
Arnaldo

Arnaldo F.
100% (16)Projects Completed
15
Freelancers worked with
12
Projects awarded
90%
Last project
22 Nov 2024
Italy
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies