Thread: Input #n
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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