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
ExcelExperts.comExcel Consultancy, VBA Consultancy, Training and Tips Call:+442081234832 |
|
Excel / VBA ConsultancyFree Training VideosFree SpreadsheetsExcel / VBA JobsNavigationWho's onlineThere are currently 0 users and 270 guests online.
New Excel Experts
Current Excel / VBA Jobs |
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 |
Highest Ranked Users
Recent Blogs
ForumsRecent comments
User login |
comma delimited
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
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