Import text file - how to delimit (noob)
 

I'm new to this, but I need to import some data from a text file into
Excel. I need info a few things:

1. How to delimit the text file so that the information goes into the
spreadsheet "gracefully" (in seperate cells).

2. Perhaps a resource or example illustrating the importing of a text
file into Excel... link?

3. Recommendations on how to script this.... (python possible?)

Thanks for the help !

Import text file - how to delimit (noob)
 

If you're using Excel 2003 why don't use use XML and just do file -
open ?

Import text file - how to delimit (noob)
 

wrote:
If you're using Excel 2003 why don't use use XML and just do file -
open ?

I've never used XML before. Is there an example of this on the web
somewhere ?

Import text file - how to delimit (noob)
 

Here's how I open a text file.

Dim UF As Variant
UF = Application.GetOpenFilename(FileFilter:="Text File
(*.txt),*.txt", Title:="Open input file")
If UF = "False" Then
' user hit cancel'
Exit Sub
End If

Workbooks.OpenText Filename:=U

--
Bruce00
-----------------------------------------------------------------------
Bruce001's Profile: http://www.excelforum.com/member.php...fo&userid=2663
View this thread: http://www.excelforum.com/showthread.php?threadid=50733