Macro Issue

[alexm999]

I've created a macro to import a text file into a Comma Delimited file
The macro to import 31 files, but everytime accesses the files (1.txt
2.txt, 3.txt...31.txt) it prompts me to click YES or NO to an erro
message that states that the TXT file is not supported. After I clic
yes, my macro runs and everything is fine. My problem is the "Yes" o
"no" issue. I dont want to click YES on every single file that th
macro imports...

Is there a way around this

 

[Dave Peterson]

I don't think I've seen that error with .txt files.

But you may want to try:

application.displayalerts = false
'import code
application.displayalerts = true

This hides a lot of warning messages--maybe yours, too.

 

[alexm999]

Thanks A LOT!

That cleaned up my macro 100% !!