G
Guest
I've set up a macro in Excel to:
1. Open a .txt file via the Text Import Wizard
2. Copy the data and paste into another worksheet
3. Close the .txt file
Three different Alert Messages pop up:
1. The first indicates the .txt is not in a recognizable format, and if I
want to view anyway..... to which i click 'OK'
2. The second asks if I want to save the .txt file...... 'No'
3. The third asks if I want to move the copied data onto the
clipboard...... 'No'
How do I set up the macro to automatically answer the alerts?
1. Open a .txt file via the Text Import Wizard
2. Copy the data and paste into another worksheet
3. Close the .txt file
Three different Alert Messages pop up:
1. The first indicates the .txt is not in a recognizable format, and if I
want to view anyway..... to which i click 'OK'
2. The second asks if I want to save the .txt file...... 'No'
3. The third asks if I want to move the copied data onto the
clipboard...... 'No'
How do I set up the macro to automatically answer the alerts?