Hello, i need help with 2 problems
1)
im coping excel ranges and inserting them on bookmars in a word document in a iterative way, the problem arises
when i try to format the pasted tables, only the first get changed and not all the chages are made by the code.
I really dont understand why it doesnt work
wordDoc.Bookmarks("tabInstADSLAITop").Range.PasteExcelTable False, False, False
Application.CutCopyMode = False
Set tbl = wordDoc.Tables(numTab)
With tbl
.Rows.HeightRule = wdRowHeightExactly
.Rows.Height = 15.6 ' +- 0.55 cm
.AutoFitBehavior (wdAutoContent)
.AutoFitBehavior (wdAutoFitWindow)
End With
wordDoc.Bookmarks("instADSLAITop").Range.InsertAfter numInst
2)
for time to time i keep getting the error 462 The remote server machine does not exist or is unavailable at this line:
Set tbl = wordDoc.Tables(numTab)
or this line:
wordDoc.Bookmarks("instADSLAITop").Range.InsertAfter numInst
Thanks
Bookmarks