Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How check for No/Cancel Button when SaveAs and file already exists?
Hello -
I have a quick question: I use the ThisWorkbook.SaveAs function to save a file but if the file already exists, Excel shows a warning. The problem is that if I say either No or Cancel, there is an exception thrown. How can I catch the result of that MsgBox()? Thanks! Joe |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How check for No/Cancel Button when SaveAs and file already exists?
Joe,
What are you tryin g to do, not save it if it already exists? If so, try trapping it, and don't save if so Function FileExists(sFilename As String) As Boolean FileExists = Dir(sFilename) < "" End Function -- HTH RP (remove nothere from the email address if mailing direct) "Joe HM" wrote in message oups.com... Hello - I have a quick question: I use the ThisWorkbook.SaveAs function to save a file but if the file already exists, Excel shows a warning. The problem is that if I say either No or Cancel, there is an exception thrown. How can I catch the result of that MsgBox()? Thanks! Joe |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How check for No/Cancel Button when SaveAs and file already exists?
Hello -
I get an error if I press either No or Cancel in the prompt that Excel will show if the file already exists: Run-time error '1004' Method 'SaveAs' of object '_Workbook' failed. Is there a way to catch that? Thanks, Joe |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How check for No/Cancel Button when SaveAs and file already exists?
Yeah, as I said
If FileExists("myfilename") Then 'do nothing Else Activeworkbook.SaveAs Filename:="myfilename" End If -- HTH RP (remove nothere from the email address if mailing direct) "Joe HM" wrote in message oups.com... Hello - I get an error if I press either No or Cancel in the prompt that Excel will show if the file already exists: Run-time error '1004' Method 'SaveAs' of object '_Workbook' failed. Is there a way to catch that? Thanks, Joe |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
How check for No/Cancel Button when SaveAs and file already exists?
Hello -
I get an error if I press either No or Cancel in the prompt that Excel will show if the file already exists: Run-time error '1004' Method 'SaveAs' of object '_Workbook' failed. Is there a way to catch that? Thanks, Joe |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
How check for No/Cancel Button when SaveAs and file already exists?
D'oh ... got you!
I just thought that the SaveAs function would return some status. Thanks! Joe |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
How check for No/Cancel Button when SaveAs and file already exists?
You can also do
On Error Resume Next ActiveWorkbook.SaveAs Filename:="C:\Mytest\Volker1.xls" On Error GoTo 0 which will give you the prompt that you can No/Cancel, but I prefer nthe first method -- HTH RP (remove nothere from the email address if mailing direct) "Joe HM" wrote in message oups.com... D'oh ... got you! I just thought that the SaveAs function would return some status. Thanks! Joe |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
How check for No/Cancel Button when SaveAs and file already exists?
Great! Thanks so much!
Joe |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Check if file exists | Excel Discussion (Misc queries) | |||
Saveas where file already exists | Excel Programming | |||
SaveAs command when a file already exists? | Excel Programming | |||
check if a file exists / is open | Excel Programming | |||
How do I check if a user clicked the Print Cancel button | Excel Programming |