ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel Import (https://www.excelbanter.com/excel-programming/424920-excel-import.html)

Brian Hein

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



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

[email protected][_2_]

Excel Import
 
You mean RSS?

Tim Williams[_2_]

Excel Import
 
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

"Brian Hein" wrote in message
...
Does anyone have a script for importing and seperating a line feed ""
delimited text file into Excel?



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





All times are GMT +1. The time now is 04:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com