Thread: Copying Excel data to Word
2014-03-03, 04:14 #1
- Join Date
- Mar 2014
- Thanked 0 Times in 0 Posts
Copying Excel data to Word
I am new to excel vba and happy to say, my life has changed by learning vba.
I have to copy paste large number of data from excel to word file.
This excel file contains objects(shapes) and text. How can I copy all these data into word.
Note : I need to copy all the text as text only.
Thank you for your help.
Subscribe to our Windows Secrets Newsletter - It's Free!
Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!
+ Get this BONUS — free!
Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!
2014-03-03, 04:48 #2
- Join Date
- May 2002
- Canberra, Australian Capital Territory, Australia
- Thanked 166 Times in 153 Posts
You can copy & paste the content, with formatting, then remove the formatting later on, so as to keep the relationship between the text & other objects intact. It's only if you want to remove any table structure that the content has that you'll encounter problems with the relationship between the text & other objects.Cheers,
[MS MVP - Word]