DEADLINE! Importing table into Word Form using a Command Button rexie3 29.09.2006 18:19:02 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.

Re: DEADLINE! Importing table into Word Form using a Command Button "Carim" <carimfam[ at ]yahoo.com> 29.09.2006 20:32:27 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 rexie3 wrote: [Quoted Text] > 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.