Forum Discussion
ShazSh
Sep 24, 2021Brass Contributor
Convert Excel Range into Word without Tables
I have created below code to copy data and paste into word the code is working fine but the problem is when it paste the data into word document then i convert the table into text. Then there are...
ShazSh
Sep 25, 2021Brass Contributor
No, Its not seems that i have the code in the workbook i forgot to paste. can you please check it.
Juliano-Petrukio
Sep 25, 2021Bronze Contributor
The code is different from yours. I developed it from scratch based on your post. Can you please test it to see if works as you wish?
- ShazShSep 25, 2021Brass Contributor
Yes it works as mine but when i convert the Word Table to Text it removes the Excel Original tables. These are https://ibb.co/G36M177 I do not wat to remove excel original tables in wod after Converting text to table
- Juliano-PetrukioSep 25, 2021Bronze Contributor
- ShazShSep 25, 2021Brass ContributorYes its was doing this before as well the real problem is i want to remove the tables (Data should be in Word Document as Text format) When i use this option https://ibb.co/WBNFGJM it convertes the data as Text Format and remove the Excel Original table as well.
I just want that all data should be formatted as text and Excel 3 Original tables will same in Word Document as you posted pictures above.