QueryTable.TextFileVisualLayout (Excel)

Returns or sets an XlTextVisualLayoutType enumeration that indicates whether the visual layout of the text being imported is left-to-right or right-to-left. Possible return values are xlTextVisualLTR - Left-to-right, xlTextVisualRTL - Right-to-left.

If you import data by using the user interface, data from a web query or a text query is imported as a QueryTable object, while all other external data is imported as a ListObject object. If you import data by using the object model, data from a web query or a text query must be imported as a QueryTable, while all other external data can be imported as either a ListObject or a QueryTable. The TextFileVisualLayout property applies only to QueryTable objects.

ActiveCell.QueryTable.TextFileVisualLayout = xlTextVisualLTR