TextConnection.TextFileVisualLayout procedure builder

TextConnection.TextFileVisualLayout (Excel)

Returns or sets an XlTextVisualLayoutType value that indicates whether the visual layout of the text being imported is left-to-right or right-to-left.

Possible Values are xlTextVisualLTR - Left-to-right, xlTextVisualRTL - Right-to-left.
ActiveWorkbook.Connections(1).TextConnection.TextFileVisualLayout = xlTextVisualLTR