| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Threaded Mode
