How to overwrite a file in a macro

I have a macro which saves the active
worksheet to a .txt tab separated file
and I'd like to modify it so that it
doesn't ask the user if he wants to
overwrite a file of the same name. I want
the macro to overwrite the file, period.

Any clues on how to do that?
thanks!
dani@3dsite.com

[Barrie Davidson]

On 2002-03-09 14:11, Anonymous wrote:
I have a macro which saves the active
worksheet to a .txt tab separated file
and I'd like to modify it so that it
doesn't ask the user if he wants to
overwrite a file of the same name. I want
the macro to overwrite the file, period.

Any clues on how to do that?
thanks!
dani@3dsite.com

Sub YourMacro()
Application.DisplayAlerts = False
'your code
Application.DisplayAlerts = True
End Sub