This should work:

Application.DisplayAlerts = False
Workbooks("ijb.xls").Close SaveChanges:=True
Application.DisplayAlerts = True

--
If I've mis-understood the question please tell me.

HTH

ijb

Remove nospam from my e-mail address to talk direct

Not MCSD, MVP, TLA, P&P, PCMCIA, etc just trying to help


"Jean-Noel Dotter" wrote in message
om...
Hello,

If I want to save a excel sheet in vba I use:

Workbooks(_FileName).Close SaveChanges:=True

but a question like "a file named ... is always existing, do you want
to exange it? <Yes <No <Cancel"

how can i do in order to save my file without such query?

Regards,

Jean-Noel