"Chris Premo" wrote in message
...
Now I have another issue. I'm saving my data as a Text file and use
this command. Unfortunately, it prompts for a use action to
save/replace the file and then prompts again when I close the file.
I'd like code that would not require use intervention.

Try
Application.Displayalerts = False
' meaning I know what i'm doing, don't ask, then
' your save code here, then
Application.Displayalerts = True

HTH. Best wishes Harald