xtremaxs

I figured people would automatically know what Text To Columns means and yea I check the Excel.au3. It doesn't have anything related to TextToColumns in it. I check this posting http://www.autoitscript.com/forum/index.php?showtopic=34302&hl=texttocolumns&st=330 but it doesnt work. As far as code, all I have is the code that opens the excel document and selects column A. CODE$oExcel = ObjCreate("Excel.Application") With $oExcel .Visible = 1 .Workbooks.Open(@DesktopDir & "\*********.xls", Default, False) .ActiveWorkbook.Sheets(1).Select() EndWith $oExcelWs1 = $oExcel.ActiveWorkbook.Sheets(1) $oExcel.Range("A:A").Select

No. Peforming a texttocolumn by comma when manipulating excel from autoit. I have a CSV file and I need to perform texttocolumns to parse it out.

Has anyone figured out how to perform delimited TextToColumns on a comma?

Has anyone figured out how to perform TextToColumns delimted on a comma?