Excel VBA to copy table into Word with additional Formatting
- or -
Post a project like this3765
$$
- Posted:
- Proposals: 6
- Remote
- #371803
- Awarded
IOS Development, Android applications developer, crm development, e-commerce development, mobile applications development, PHP programming language, software development, website development
Harrow on the Hill
195397393290459350483425548700567751
Description
Experience Level: Intermediate
Estimated project duration: less than 1 week
Dear all
I have started to program an Excel VBA which copies a range from an Excel table to a bookmarked location in the actively used Word document.
I am not a VBA expert but try to be more efficient in programming small VBA programs which help me in my daily work.
Copying the table works fine, but I need some additional features I can't figure out:
1. The program should check if there is already a table at the location of the bookmark and if yes delete it. Selection.Tables(1) does not work, as there are already other tables in the document.
2. After the program copies the (new) table to the bookmarked location, it should adjust the row size.
Further information can be found in the code example I uploaded.
Kind regards
I have started to program an Excel VBA which copies a range from an Excel table to a bookmarked location in the actively used Word document.
I am not a VBA expert but try to be more efficient in programming small VBA programs which help me in my daily work.
Copying the table works fine, but I need some additional features I can't figure out:
1. The program should check if there is already a table at the location of the bookmark and if yes delete it. Selection.Tables(1) does not work, as there are already other tables in the document.
2. After the program copies the (new) table to the bookmarked location, it should adjust the row size.
Further information can be found in the code example I uploaded.
Kind regards
Dave M.
100% (1)Projects Completed
2
Freelancers worked with
2
Projects awarded
50%
Last project
22 Sep 2017
Switzerland
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