Hello,
I am trying to build a Straight Tables via a macro, given that depending on the user selection, a different table needs to be loaded each time, at the same location.
One of the issues is that given that situation, I would like to delete the past table, before creating a new table with same Object ID (the same ID is required for fuctionality of the document).
Based on the GetObject statement I tried "ActiveDocument.RemoveSheetObject("Table")".
What is the correct syntax to delete a sheet object ?
Also there is one column where I need to sort via a custom order.
Hence I used:
Table.GetProperties.Dimensions.Item(0).SortCriteria.SortByExpression = 1
Table.GetProperties.Dimensions.Item(0).SortCriteria.Expression.v = "=Match([Current State] , 'Submitted'" , 'Analysis Started')"
What is the correct way to phrase this ?
Lastly if possible, I would like to auto-width the columns, similar to manually selecting "Fit Columns To Data"
Is this possible, or do I need to set the column width manually to a fixed value ?
Thank you for your help
