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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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