the easiest might be to make the textfile in a format that is recognizable.
I haven't run across a true textfile that causes this prompt.

--
Regards,
Tom Ogilvy


"Bafana" wrote in
message ...

I have set up a macro to import multiple text files. When opening the
text file(s) the following error/warning msg appears -"This file is not
a recognisable format"-. The macro then suspends until you select "OK"
on the msg.

Is there any way to avoid having to press "Enter" (i.e. to select "OK")
as I am getting a bit fustrated "OK"-ing about 50 times (the number of
text files) each time I import.

Tx


--
Bafana
------------------------------------------------------------------------
Bafana's Profile:
http://www.excelforum.com/member.php...o&userid=27693
View this thread: http://www.excelforum.com/showthread...hreadid=472082