save a excel sheet in vba

[Jean-Noel Dotter]

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

 

[ijb]

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

 

[Bob Phillips]

Jean-Noel,

Put
Application.DisplayAlerts = False

and reset afterwards

 

[tokash]

Try:

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

Tokash

 

[Bill Lunney]

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/DisplayFAQ.ascx?ExcelFAQID=75


--
Regards,


Bill Lunney
www.billlunney.com