DEADLINE! Importing table into Word Form using a Command Button

[rexie3]

I'M ON A DEADLINE!!
I've an Excel sheet that is saved.
I want to use a Command Button in my Word form to trigger Word to find the
Excel sheet and import it into my Word document.

I inserted the file as an object in my word document and looked fine but I
don't know how to use a Command Button to do the same.

Thank you very much.

 

[Carim]

Hi,

A two step process ...
1. Tools Macro Record a new Macro
will allow you to have all the steps of your import recorded

2. View ToolBars Control ToolBox
will allow you to insert a Command Button
adjust Properties
View Code to insert following instruction :

Private Sub CommandButton1_Click()
Application.Run ("YourMacro")
End Sub

HTH
Cheers
Carim