Disable text import error message "This file is not in a Recognizable Format"

[Jeff Koons]

I'm currently using a macro to open a text file, format
it for use in Access, and save it in an Excel format.
When the macro is run it opens the text file. At this
point I get the following error message, "This File is
not in a Recognizable Format". I would like to disable
this message box so that the end user will only have to
click the macro button to format the file. Does anyone
know if there is a way to do this?

Thanks,
Jeff

 

[Dave Peterson]

Try turning off the display of alerts:

Application.DisplayAlerts = False
Workbooks.OpenText .....
Application.DisplayAlerts = True