Excel Import

[Brian Hein]

Does anyone have a script for importing and seperating a line feed "
"
delimited text file into Excel?



*** Sent via Developersdex http://www.developersdex.com ***

 

[gimme_this_gimme_that]

You mean RSS?

 

[Tim Williams]

I think if you recprd a macro when opening a text file and set "origin" to
Macintosh it should give you what you need.

Otherwise, use the filesystemobject to read in the whole file, split the
string on Chr(10) (or 13, I forget) and then iterate through the array and
write the lines to the sheet.

Tim