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 return values are xlTextVisualLTR - Left-to-right, xlTextVisualRTL - Right-to-left.

ActiveWorkbook.Connections(1).TextConnection.TextFileVisualLayout = xlTextVisualLTR