Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy information from Excel to Word using 1 macro | Excel Discussion (Misc queries) | |||
Copy from WORD to EXCEL using a macro..... | Excel Discussion (Misc queries) | |||
Macro to copy a word doc into an excel doc | Excel Discussion (Misc queries) | |||
copy from Excel to Word by macro with certain for | Excel Discussion (Misc queries) | |||
copy from Excel to word by macro with certain format | Excel Discussion (Misc queries) |