Sorry, I hit send by mistake,

Try wrapping the code in

Application.DisplayAlerts = False
'Your Code
Application.DisplayAlerts = True

This works for XL files, not sure about Text Files but worth a try,
Regards,
Alan.
"Alan" <[email protected]> wrote in message news:...
> Try wrapping the code in
>
> Application.DisplayAlerts = False
> 'Your Code
>
> "Stuart Macro Muppet" <Stuart Macro [email protected]>
> wrote in message
> news:[email protected]...
>>I have created a macro that opens 4x text format files as Excel files,
>>which
>> copies and pastes their data into a master excel template.
>> The 4x text files are inserted into one data sheet, the updated data
>> sheet
>> forms the basis for several pivot tables which are then run by the macro.
>> The macro created closes the 4x text files when they have been copied.
>>
>> When closing the text files the prompt "Do You Want To Save xxxxx.txt?"
>> appears, requiring manual intervention to select NO. The macro continues,
>> the
>> prompt appears 4 times for each file.
>>
>> The macro is required daily, no data manipulation of the text files
>> occurs,
>> they are only opened, copied, and closed.
>>
>> I do not want the Save Prompt appearing.
>>
>> How can I remove this?
>>
>> Many thanks

>
>