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

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

Perfect
Thanks

--
_________________________________
Cameron Land Surveying Ltd.
#203 - 6333 148th Street,
Surrey, BC
V3S 3K4
(p) (604) 597-3777
(f) (604) 597-3783

All messages scanned with Norton Antivirus
"Rafael Guerreiro Osorio"
wrote in message ...
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