save a excel sheet in vba
 

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

save a excel sheet in vba
 

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

save a excel sheet in vba
 

Jean-Noel,

Put
Application.DisplayAlerts = False

and reset afterwards



--

HTH

Bob Phillips

"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

save a excel sheet in vba
 

Try:

Application.DisplayAlerts = False
Workbooks(_FileName).Close SaveChanges:=True
Application.DisplayAlerts = True

Tokash

-----Original Message-----
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
.

save a excel sheet in vba
 

There are two main ways of stopping the save confirmation dialog appearing.

Application.DisplayAlerts = False will suppress the dialog box from
appearing in the first place.
Workbooks("fred").Close SaveChanges:=True
A couple of points to note:

If using the first option remember to turn the alerts back on (True) when
you're done.
The SaveChanges property will only work as you expect if the file access
etc. is read/write. I mention this as people have assumed the method
doesn't work but it's been due to workbooks opened in read only mode etc.


http://www.billlunney.com/Excel/FAQ/...?ExcelFAQID=75


--
Regards,


Bill Lunney
www.billlunney.com

"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