Hi,

I'm trying to open a fixed width text file in excel using macro, but before opening the file there is always a "This file is not in a recognise format" msg. How can I disable this msgbox from popping out?

Please help!

Thanks & Regards,
oks

Rather than disable the message, wouldn't it be better to put an error handler in there as a wrong format is being flagged?

Hi

All you need to do is before you open the file use the line

Application.DisplayAlerts = False

This restricts all pop up messages
Once you have passed this point you should set

Application.DisplayAlerts = True

HTH
David