Try this:

Sub OpenWBK()
Workbooks.OpenText "d:\myfile", , , , , , , , True
End Sub

Select OpenText and press F1 for info on all the options of this method.

Best,

Rafael

"CLS" wrote:

Hi All,

Looking for VBA code to open/import an ascii file w/ comma delimits.
Workbook.open "asciifile" dumps each full line into the first cell. I want
it delimited by commas.

Thanks
Chad