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.

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