Can't find the information you are looking for here? Then leave a message over on our WinBatch Tech Support Forum.
Keywords: Import Tab Delimited Text TXT File Excel OpenText
; Import Tab Delimited Text File ; Macro recorded in Excel ;--------------------- ;Workbooks.OpenText Filename:="D:\temp\DATA\Tabdelim.txt", Origin:=437, _ ; StartRow:=1, DataType:=xlDelimited, TextQualifier:=xlDoubleQuote, _ ; ConsecutiveDelimiter:=False, Tab:=True, Semicolon:=False, Comma:=False _ ; , Space:=False, Other:=False, FieldInfo:=Array(Array(1, 1), Array(2, 1)), _ ; TrailingMinusNumbers:=True ; Translated to WIL ;--------------------- objExcel = ObjectCreate("Excel.Application") ; Define Excel Constants const = ObjectConstantsGet( objExcel ) xlDelimited = const.xlDelimited xlDoubleQuote = const.xlDoubleQuote ; Make Excel Visible objExcel.Visible = @TRUE ; Import Tab Delimited Text File objExcel.WorkBooks.OpenText(::Filename="D:\temp\DATA\Tabdelim.txt", Origin=437, StartRow=1, DataType=xlDelimited, TextQualifier=xlDoubleQuote, ConsecutiveDelimiter=@FALSE, TAB=@TRUE) ; Close Object Handle objExcel = 0 Exit
Article ID: W18111
Filename: Import Tab Delimited Text File.txt
File Created: 2009:07:23:09:15:20
Last Updated: 2009:07:23:09:15:20