Input #n

[keith]

Hello,
I need to input a string that is delimited with spaces.
The Input #n statement does an excellent job with a comma
delimited file. The example ..

Input #1, Myval1, Myval2

.... is great.

I need the same thing for a space delimited file. Is
there anything as short and succinct as Input #1

Keith

 

[Keith]

HI Tom,
Thanks very much.

Keith

-----Original Message-----
No, but you can use code written by Chip Pearson to specify the delimiter:

http://www.cpearson.com/excel/imptext.htm

If it is actually delimited and not fixed width.

--
Regards,
Tom Ogilvy




.