Hi All,
I'm trying to import a table from Excel directly into word. I can't find a way to pull the table itself in, and I'd prefer not to use a range as the table will be a varying number of rows depending on the source file. I also want to use specific Cells in the table to create headings earlier in the file, but the number of cells will be dynamic. Current code works fine to import a single cell, but can't figure out the exWB for a table. Any suggestions? Thanks much

Private Sub CommandButton1_Click()
Dim objExcel As New Excel.Application
Dim exWb As Excel.Workbook


Set exWb = objExcel.Workbooks.Open("C:\Users\Me\Desktop\SOWTest\CostingsCalculator.xls x")


ThisDocument.ImportFromCostCalc.Caption = exWb.Sheets("Customer Facing (Std)").Range("B2")


exWb.Close


Set exWb = Nothing


End Sub


Private Sub ImportCost_Click()


End Sub