Microsoft Office Forums - View Single Post - Convert Text To Table: Separate text at (Other)?

tinfanide · 01-11-2015, 12:37 AM

Code:

Sub ConvertTextToTable()
    
Dim oRange As Word.Range
     
If ActiveDocument.Bookmarks("bmTable").Range.Tables.Count <> 0 Then Exit Sub
 
Set oRange = ActiveDocument.Bookmarks("bmTable").Range
oRange.ConvertToTable Separator:=???
 
Set oRange = Nothing
End Sub

I wonder how I can use other separators / delimiters, in my example that is a pipe ("|"). Please see the ??? in the codes above.

Thanks!