Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save Excel spread sheet | Excel Discussion (Misc queries) | |||
Save excel sheet | Excel Discussion (Misc queries) | |||
Save, save as, page setup dimmed out in unprotected excel sheet? | Excel Discussion (Misc queries) | |||
VBA code to save excel sheet | Excel Discussion (Misc queries) | |||
save from template to excel sheet | Excel Discussion (Misc queries) |