macro in excel to copy from excel to word
i have a database in excel...which i would like to take more advantage
of. I also have some forms in Word that I was hoping to be able to get them to be automatically completed using the excel database. Initially thought this would be quite simple.... just record the macro then modify it to suit. This using simple copy from excel and paste into word document, or pasting into form..field..values. Preferably modifying the values of fields in the form. The form is protected, and some fields are entered manually. I have done a little before with excel macros - to a level of 'using excel programming for dummies' book. But really do not know where to start now. Have seen this: "Dim appWD As Word.Application Set appWD = CreateObject("Word.Application.8") appWD.Visible = True" but not sure how this all fits in. can anybody help guide me in the right direction or know of a good simple book. not really into this heavy would just like to know how to get this simple task done for now. not much point in learning loads of stuff i will just forget, because i wont use it again for a while. thanks steve |
macro in excel to copy from excel to word
Have you tried using Word's Mail Merge feature to pull the data from Excel?
There's information on the Word MVPs' web site: http://www.mvps.org/word/FAQs/MailMerge/ Stephen Murray wrote: i have a database in excel...which i would like to take more advantage of. I also have some forms in Word that I was hoping to be able to get them to be automatically completed using the excel database. Initially thought this would be quite simple.... just record the macro then modify it to suit. This using simple copy from excel and paste into word document, or pasting into form..field..values. Preferably modifying the values of fields in the form. The form is protected, and some fields are entered manually. I have done a little before with excel macros - to a level of 'using excel programming for dummies' book. But really do not know where to start now. Have seen this: "Dim appWD As Word.Application Set appWD = CreateObject("Word.Application.8") appWD.Visible = True" but not sure how this all fits in. can anybody help guide me in the right direction or know of a good simple book. not really into this heavy would just like to know how to get this simple task done for now. not much point in learning loads of stuff i will just forget, because i wont use it again for a while. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
macro in excel to copy from excel to word
Hi steve,
FYI, also you can you BOOKMARKS of word like this. http://www.mrexcel.com/board2/viewto...0239&highlight -- Message posted from http://www.ExcelForum.com |
All times are GMT +1. The time now is 11:44 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com