Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can Excel Execute a Word Document and Insert Data?
Is there a way to click on a part number in a list in Excel that will open a
Word document that contains a form letter with the part number inserted that was originally selected in the Excel list? I thought of hyperlinks from a mail merge, but the list contains about 8000 part numbers. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can Excel Execute a Word Document and Insert Data?
You could use a Selection Change event to pick up the contents of a newly
selected cell and then execute some code to open the word document and insert the value Private Sub Worksheet_SelectionChange(ByVal Target As Range) MsgBox Target.Address & " = " & Target.Value End Sub You could restrict the event to a single column or even a range ... or you could manually execute a macro having selected the data. I think the easiest way is to have bookmarks in the word document where you want to add data. Regards Trevor "Shazam" wrote in message ... Is there a way to click on a part number in a list in Excel that will open a Word document that contains a form letter with the part number inserted that was originally selected in the Excel list? I thought of hyperlinks from a mail merge, but the list contains about 8000 part numbers. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert Excel hyperlink to word document | Excel Worksheet Functions | |||
Want to insert Excel sheet in Word document - comes out too big. | Excel Discussion (Misc queries) | |||
Can I insert a word document into a new excel file ? | Excel Discussion (Misc queries) | |||
Help, insert a word document contents into excel tab? | Excel Discussion (Misc queries) | |||
insert multiple page Word document into Excel | Excel Discussion (Misc queries) |