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.
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
