link excel to word

ganeshm · #1 03-26-2013, 11:46 PM

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

Kindly verify this and suggest me.

macropod · #2 03-27-2013, 01:29 AM

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.

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