Excel VBA
Thanks Bob
"Bob Phillips" wrote:
Precede the code with
Application.DisplayAlerts = False
and reset afterwards.
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"gregory" wrote in message
...
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?
|