I have set up a macro to import multiple text files. When opening th
text file(s) the following error/warning msg appears -"This file is no
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 o
text files) each time I import.

Tx :confused

--
Bafan
-----------------------------------------------------------------------
Bafana's Profile: http://www.excelforum.com/member.php...fo&userid=2769
View this thread: http://www.excelforum.com/showthread.php?threadid=47208