Hello Everyone!
I have a range of data on Sheet6.Range(A4:C). I need to post each cell in the Range(A4:C) to an existing Word table beginning in (C1,R5). Obviously, I need each excel row in a separate row of the Word table. Here are the parameters:
- The Word document is open
- The table is bookmarked "MyTable"
- The columns are bookmarked ("Folder_Number","Code","Description") in the beginning row(5).
Thank you all for any assistance you can provide!
Hello ericv101,
If you could post copies of both the Excel workbook and Word document, it will make it easier to code and test solutions. Most people are not inclined to recreate your work from scratch.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Hi Leith -
I agree and apologize. Unfortunately, I cannot post the Workbook or the Word Doc as they are both sensitive and proprietary. I can add a portion of the existing Excel code:
I wish I could post both pieces as you've suggested. Again, I apologize and understand if it prohibits assistance.
Please Login or Register to view this content.
Hello ericv101,
Does this Word table need to add rows to hold the Excel data?
Hi Leith -
Yes, the Word table has information in rows 1-4. This will need to begin on row 5 and continue until the excel range is complete. I've been working with this:
It seems to be pulling all the information over but not incrementing and adding next row. It's just expanding the cells in the word table. Thanks for taking a shot at it with less than all the info.Please Login or Register to view this content.
-Eric
Hello ericv101,
This should be a good start. This will add rows to the table from the Excel worksheet to the end of the Word table. I assumed that row 5 was the end of the table. Let me know what changes need to be made.
Please Login or Register to view this content.
Hi Leith -
Thank you so much! I think it will do the trick!
-Eric
Hello ericv101,
Test it out really well just to be sure. I have some code in there to start Word if Word is already open. This will fail because there is no path for the document to be opened. The macro assumes there is only 1 document in the open Word application and it is the one you want.
Will do. I think I can make the mods required. Thanks again!
Hello Eric,
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks