delimiting data before the data file is being import

[ksboyz]

i like to know is there any way to make my program which embedded in Excel
to delimit the data before it was inputed into the Exel workbook
the raw data was separated by space or a tab.by the way, the file format is
*.prn
i knew that is function in Excel to delimit the data, but can i do it within
a VB control in Excel......
thanks for generous help


sincerely from
kean hee
25/0072003

 

[Kim Mitchell]

If you do not want to use Excel's built-in delimiter capability, then with
vba, you can open the file as a sequential file. You read each line and
parse it as you wish applying whatever delimiting is needed. You can write
it to the spreadsheet or save it to an array, whatever. Then go for the
next line. In Help, see "Open", "Input", Line Input #", "Instr", "Mid",
"Left" and "Right".

Kim