Macro Issue

  • Thread starter Thread starter alexm999
  • Start date Start date
A

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
 
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.
 
Back
Top