Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy a form from excel into a new word document
Could you tell me the vba code to copy a document from excel and paste it
into a new word document? many thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy a form from excel into a new word document
Hello Kevin
One way could be to record a macro in word while doing the import by hand. then go to tools|macro|visualbasiceditor and there you find newmacros from normal|modules that contains recorded macrocodes. Here is example code I recorded while importing an excel document to word Selection.InlineShapes.AddOLEObject ClassType:="Excel.Sheet.8", FileName:= _ "pathtodocument\documentname.xls", _ LinkToFile:=False, DisplayAsIcon:=False hope this helps ..nippetee "kevin" kirjoitti: Could you tell me the vba code to copy a document from excel and paste it into a new word document? many thanks. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy a form from excel into a new word document
Kevin, do you want to 'copy a form' (as in your subject line) or 'copy a
document (as in your message)? To 'copy a form', in Excel, export the form to a file (File + Export file) and import that file in Word (File + Import File) "kevin" wrote: Could you tell me the vba code to copy a document from excel and paste it into a new word document? many thanks. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy a form from excel into a new word document
Hi,
Sorry I didn't explain myself clearly. I want the user to activate a button which will copy a cell range from excel and paste it into a word document ? Can you help. "AA2e72E" wrote: Kevin, do you want to 'copy a form' (as in your subject line) or 'copy a document (as in your message)? To 'copy a form', in Excel, export the form to a file (File + Export file) and import that file in Word (File + Import File) "kevin" wrote: Could you tell me the vba code to copy a document from excel and paste it into a new word document? many thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Form attached to a Word Document Letter | Excel Discussion (Misc queries) | |||
send document from Excel to Word in readable form | Excel Discussion (Misc queries) | |||
How do I copy a Word document into Excel and have it look good? | Excel Discussion (Misc queries) | |||
can we link fields from a form in word document to excel | Excel Discussion (Misc queries) | |||
Link a form field in a Word document to populate an excel spreads | Excel Discussion (Misc queries) |