"Manuel Soares" wrote in message
...
Thanks for the suggestion, but I don't think it'll suit my needs. Let
me explain further, as I wasn't very clear before. The macro pulls
(copies then pastes) data from text files, then closes said text files.
3 times while running the macro I receive the following message:

'FILE NAME' is not in Microsoft Excel 97 format. Do you want to save
your changes?

I manually click NO to these prompts.

I also receive a message that says the following:

A file named 'File Name' already exists in this location. Do you want
to replace it?

I manually click YES to this prompt (it's necessary that this particular
file is overwritten each time the macro runs).

So I'm not sure the command you suggested would work becaue I'm dealing
with closing text files after I've imported data into Excel, and not
Workbooks. Do you have any other suggestion?

I appreciate any help you can provide.

Manuel


You can suppress these messages by using the command
Application.DisplayAlerts = False

dont forget to turn them on again when you are done :)

Keith




----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---