Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error on ActiveWorkbook.SaveAs method
Hi there,
I hope there is a really simple answer to this but I have not been abl to find a simple solution to error trapping the ActiveWorkbook.SaveA method. When the following command runs (inside a macro) and I selec 'yes' from the dialog box when it says "the file already exists do want to replace it?" - that's fine. When I select 'no' or 'cancel' th following error occurs... Runtime Error 1004: "Method 'SaveAs' o object '_workbook' failed The method is: (where sWorkBookPath and sFileName are variables for m path and filename) ActiveWorkbook.SaveAs Filename:=sWorkBookPath & "\" _ & sFileName & ".txt", FileFormat:=xlText, CreateBackup:=False How do I stop the macro crashing when I select 'no' Kindy Regards And -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error on ActiveWorkbook.SaveAs method
try putting in either
On Error Resume Next O On Error Goto Or handle the specific erro On Error GoTo ErrHandler ErrHandler If Err.Number = 1004 And Err.Description = "Method 'SaveAs' of object '_workbook' failed" The Resume Nex End If Make sure you match the description exactly as it shows up in the error ----- cruisy wrote: ---- Hi there I hope there is a really simple answer to this but I have not been abl to find a simple solution to error trapping the ActiveWorkbook.SaveA method. When the following command runs (inside a macro) and I selec 'yes' from the dialog box when it says "the file already exists do want to replace it?" - that's fine. When I select 'no' or 'cancel' th following error occurs... Runtime Error 1004: "Method 'SaveAs' o object '_workbook' faile The method is: (where sWorkBookPath and sFileName are variables for m path and filename ActiveWorkbook.SaveAs Filename:=sWorkBookPath & "\" & sFileName & ".txt", FileFormat:=xlText, CreateBackup:=Fals How do I stop the macro crashing when I select 'no Kindy Regard And -- Message posted from http://www.ExcelForum.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error on ActiveWorkbook.SaveAs method
If you always want to save the workbook, this macro won't ask any questions.
It will just save. Application.DisplayAlerts = False ActiveWorkbook.SaveAs Filename:=sWorkBookPath & "\" _ & sFileName & ".txt", FileFormat:=xlText, CreateBackup:=False Application.DisplayAlerts = False "cruisy " wrote in message ... Hi there, I hope there is a really simple answer to this but I have not been able to find a simple solution to error trapping the ActiveWorkbook.SaveAs method. When the following command runs (inside a macro) and I select 'yes' from the dialog box when it says "the file already exists do I want to replace it?" - that's fine. When I select 'no' or 'cancel' the following error occurs... Runtime Error 1004: "Method 'SaveAs' of object '_workbook' failed The method is: (where sWorkBookPath and sFileName are variables for my path and filename) ActiveWorkbook.SaveAs Filename:=sWorkBookPath & "\" _ & sFileName & ".txt", FileFormat:=xlText, CreateBackup:=False How do I stop the macro crashing when I select 'no' Kindy Regards Andy --- Message posted from http://www.ExcelForum.com/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error on ActiveWorkbook.SaveAs method
Thanks guys - both solutions worked a treat.
Cheers :) --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SaveAs method error | Excel Discussion (Misc queries) | |||
Max charactors for 'ActiveWorkbook.SaveAs Filename'? | Excel Worksheet Functions | |||
Question Using SaveAs Method | Excel Programming | |||
Error Excel: 1004 SaveAs method of Workbook class failed | Excel Programming | |||
SaveAs method | Excel Programming |