#1
|
|||
|
|||
link excel to word
Hi Experts,
I have a formula from excel, which retrieves sheet 2 data to sheet 1 with the use of activex control (form control) button. But i want to make a command button in word and link to excel to retrieve data. Coding is below: Code:
Sub LoadData() Dim rng As Range Sheets("Sheet1").Range("A4:A14").Clear Set rng = Sheet2.Cells(1, 1).CurrentRegion With rng .AutoFilter 4, Sheets("Sheet1").Buttons(Application.Caller).Caption .SpecialCells(12).Copy Sheets("Sheet1").Range("A4") .AutoFilter End With End Sub |
#2
|
||||
|
||||
If you want to link a Word document to a particular Excel range, so that the document updates when the Excel workbook updates, copy the range, then paste it into Word, using Paste Special with the 'Paste Link' option and the paste format of your choice. No code required.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel Link in word | chandan56 | Office | 3 | 07-02-2015 07:07 PM |
link conditional info in word based on excel list | stijnvanhoof | Mail Merge | 1 | 11-13-2012 01:55 PM |
Help Plz! Link Excel data to Word document | cory_0101 | Office | 1 | 09-27-2012 07:15 PM |
Excel into word Equation editor with live link | technopersia | Excel | 0 | 11-25-2011 09:05 AM |
Is it possible to link an Excel File to a Word table? | KIM SOLIS | Excel | 9 | 09-08-2011 07:05 AM |