Input #n
 

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

Input #n
 

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

"keith" wrote in message
...
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

Input #n
 

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

"keith" wrote in
message
...
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


.