You've got to go thru the dictionaries, Warren:
Private Sub MakeTableStyle()
'+--creates a TableStyle object
Dim oDict As AcadDictionary
Dim aColor As New AcadAcCmColor
Dim oTblSty As AcadTableStyle
Dim sKeyName As String
Dim sClassName As String
'grab the tablestyle dictionary object
Set oDict = ThisDrawing.Database.dictionaries.Item("acad_tablestyle")
sKeyName = "NewStyle"
sClassName = "AcDbTableStyle"
'create the TableStyle object in the dictionary
Set oTblSty = oDict.AddObject(sKeyName, sClassName)
With oTblSty
.Name = "Excel2Table"
.Description = "Excel2Table AutoStyle"
.HorzCellMargin = 0.22
.TitleSuppressed = False
.SetTextHeight 3, 1.3
.SetGridVisibility 3, 3, True
.SetAlignment 3, acMiddleCenter
aColor.SetRGB 244, 0, 0
End With
End Sub
--
___________________________
Mike Tuersley
CADalyst's AutoCAD Clinic
Rand IMAGINiT Technologies