Open/Import ASCII file

C

CLS

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
 
G

Guest

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
 
C

CLS

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Best way to format a flat file that Excel will load properly? 8
Open Sharepoint Hosted Excel File, in Excel, Using VBA 3
Import File Line by Line 1
Import Data, using a command line switch 1
removing commas in csv 4
what is the way to select ASCII file and import it into excel sheet? 2
Import a comma delimited file & match records 3
Importing Txt file into Excel 9

Top