Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving
Is there a way to save so that is automatically replaces
an existing file, without asking the user? This is what I am currently using: ActiveWorkbook.SaveAs Filename:="C:\Dir\filename.xls", _ FileFormat:=xlNormal, Password:="", WriteResPassword:="", _ReadOnlyRecommended:=False, CreateBackup:=False ActiveWorkbook.SaveAs Filename:="C:\Dir\filename.csv", FileFormat _:=xlCSV, CreateBackup:=False Thanks for your help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving
Hi
try: application.displayalerts=false 'saving code application.displayalerts=true -- Regards Frank Kabel Frankfurt, Germany "Cindy" schrieb im Newsbeitrag ... Is there a way to save so that is automatically replaces an existing file, without asking the user? This is what I am currently using: ActiveWorkbook.SaveAs Filename:="C:\Dir\filename.xls", _ FileFormat:=xlNormal, Password:="", WriteResPassword:="", _ReadOnlyRecommended:=False, CreateBackup:=False ActiveWorkbook.SaveAs Filename:="C:\Dir\filename.csv", FileFormat _:=xlCSV, CreateBackup:=False Thanks for your help. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving
Thank you so much, it worked perfect.
-----Original Message----- Hi try: application.displayalerts=false 'saving code application.displayalerts=true -- Regards Frank Kabel Frankfurt, Germany "Cindy" schrieb im Newsbeitrag ... Is there a way to save so that is automatically replaces an existing file, without asking the user? This is what I am currently using: ActiveWorkbook.SaveAs Filename:="C:\Dir\filename.xls", _ FileFormat:=xlNormal, Password:="", WriteResPassword:="", _ReadOnlyRecommended:=False, CreateBackup:=False ActiveWorkbook.SaveAs Filename:="C:\Dir\filename.csv", FileFormat _:=xlCSV, CreateBackup:=False Thanks for your help. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
saving | Excel Discussion (Misc queries) | |||
Automaticly saving formula's to values when saving | Excel Discussion (Misc queries) | |||
saving to CD | Excel Discussion (Misc queries) | |||
Saving XLS to CSV | Excel Discussion (Misc queries) | |||
Saving a Workbook: Forcing User to Rename before Saving | Excel Programming |