Home » Image Galleries » Screen Shots

import-a-text-file-2

Nick's picture
Submitted by Nick on 13 May, 2009 - 09:18
import-a-text-file-2


Screen shot 2 of VBA Tips - Import A Text File

Follow this link for whole Excel Tip on how to Import A Text File

»

comma delimited

Submitted by Anonymous on 29 July, 2011 - 17:51.

Thankyou so much for this tutorial, but what if the .txt file is comma delimited ? I've been trying to work on this.. Please help !

»

Workbooks.OpenText

Submitted by AndyLitch on 21 November, 2012 - 07:29.

Workbooks.OpenText Filename:="C:\myfile.txt", Origin _
:=xlMSDOS, StartRow:=1, DataType:=xlDelimited, TextQualifier:= _
xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=False, Semicolon:=False _
, Comma:=True, Space:=False, Other:=False

»