Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ActiveWorkbook.SaveAs Problem
Hello:
I am using ActiveWorkbook.SaveAs "filepath\filename" and it is working just fine the first time around. Every time after that I get the Excel MsgBox that informs me that the filename already exists and do I want to overwrite. Since I have about 1300 files to do this with, I would prefer to be able to force the ActiveWorkbook.SaveAs with no MsgBox. Is it possible or do i have to test for the file first and delete it before doing the SaveAs? "Pigs can't be humans, but humans can be Pigs!" Eating at the trough of life. Oink! SowBelly |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
ActiveWorkbook.SaveAs Problem
Application.DisplayAlerts = False
should work. Regards Kevan -----Original Message----- Hello: I am using ActiveWorkbook.SaveAs "filepath\filename" and it is working just fine the first time around. Every time after that I get the Excel MsgBox that informs me that the filename already exists and do I want to overwrite. Since I have about 1300 files to do this with, I would prefer to be able to force the ActiveWorkbook.SaveAs with no MsgBox. Is it possible or do i have to test for the file first and delete it before doing the SaveAs? "Pigs can't be humans, but humans can be Pigs!" Eating at the trough of life. Oink! SowBelly . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
ActiveWorkbook.SaveAs Problem
Hi SowBelly,
Try: Application.DisplayAlerts = False ActiveWorkbook.SaveAs " "filepath\filename"" Application.DisplayAlerts = True "SowBelly" wrote in message ... Hello: I am using ActiveWorkbook.SaveAs "filepath\filename" and it is working just fine the first time around. Every time after that I get the Excel MsgBox that informs me that the filename already exists and do I want to overwrite. Since I have about 1300 files to do this with, I would prefer to be able to force the ActiveWorkbook.SaveAs with no MsgBox. Is it possible or do i have to test for the file first and delete it before doing the SaveAs? "Pigs can't be humans, but humans can be Pigs!" Eating at the trough of life. Oink! SowBelly |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
ActiveWorkbook.SaveAs Problem
Norman:
Worked great! SowBelly On Wed, 4 Aug 2004 01:29:29 +0100, "Norman Jones" wrote: Hi SowBelly, Try: Application.DisplayAlerts = False ActiveWorkbook.SaveAs " "filepath\filename"" Application.DisplayAlerts = True "SowBelly" wrote in message .. . Hello: I am using ActiveWorkbook.SaveAs "filepath\filename" and it is working just fine the first time around. Every time after that I get the Excel MsgBox that informs me that the filename already exists and do I want to overwrite. Since I have about 1300 files to do this with, I would prefer to be able to force the ActiveWorkbook.SaveAs with no MsgBox. Is it possible or do i have to test for the file first and delete it before doing the SaveAs? "Pigs can't be humans, but humans can be Pigs!" Eating at the trough of life. Oink! SowBelly |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
ActiveWorkbook.SaveAs Problem
Kevan:
Worked great! Oink! SowBelly On Tue, 3 Aug 2004 17:29:10 -0700, "kevan hanson" wrote: Application.DisplayAlerts = False should work. Regards Kevan -----Original Message----- Hello: I am using ActiveWorkbook.SaveAs "filepath\filename" and it is working just fine the first time around. Every time after that I get the Excel MsgBox that informs me that the filename already exists and do I want to overwrite. Since I have about 1300 files to do this with, I would prefer to be able to force the ActiveWorkbook.SaveAs with no MsgBox. Is it possible or do i have to test for the file first and delete it before doing the SaveAs? "Pigs can't be humans, but humans can be Pigs!" Eating at the trough of life. Oink! SowBelly . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Max charactors for 'ActiveWorkbook.SaveAs Filename'? | Excel Worksheet Functions | |||
activeworkbook.saveas - saving format changes | Excel Programming | |||
activeworkbook.saveas | Excel Programming | |||
Error on ActiveWorkbook.SaveAs method | Excel Programming | |||
Error on ActiveWorkbook.SaveAs method | Excel Programming |