98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Copying data from Excel to Word
Copying data from Excel to Word
Resolved · Medium Priority · Version 2013
Fri 9 Feb 2018, 13:00Delegate Michael said...
Michael has attended:
No courses
Copying data from Excel to Word
I have a table containing a lost of "string" style data
This needs to be used in multiple places in slightly differing formats. The quickest/easiest method for me to do so is to fill in the initial table, and then lift this to a word document where it can be worked on, however this is an arduous process to do manually
The relevant line of data will be one in the table, and I can easily code an iterative Do loop to locate the relevant line, but I have no experience of object variables. How do I then get Excel to create a new word document, copy the line and paste "text only" into the new sheet.
There are 27 columns worth of data to move A:AA, and it will only ever be one row at a time. I know how to do this to a new excel spreadsheet, but I have no experience linking Word to Excel, which is the preferred method employed by my working team.
Sat 10 Feb 2018, 13:42Trainer Jens said...
RE: Copying data from Excel to Word
Hi Michael,
Thank you for the forum question.
To control Word from Excel you will need knowledge of object variables to create the reference to the Word Application object, the Word Document object, and may be more objects in Word. You will also need to be able to do Word VBA.
The best way of reference the Word Object is to activate the Word Object Library from Excel. This will make your code faster and Excel will provide you with intellisense help.
If you do not have experience with object variables I will suggest that you come on our Excel Advanced VBA course. We are controlling databases, Word, and Outlook from Object variables and much more during the two days the course takes.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Closing all your workbooks QuicklyHold the SHIFT key down and using the mouse click on the file menu, it will now now CLOSE ALL rather than close. This closes all workbooks down but still leaves the application open. |
