Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Error when already same name / Macro save as cell contents
Hi,
I'm getting back to this old question, some problems doesn't go away. I have this macro and it works fine until invoice has already been saved. First ofcourse excel wants to know if I want replace earlier file - no - next popup is "Runtime error 1004 Method 'SaveAs' of object '_Workbook' failed. How can I get excel to say for ex "file couldn't be saved, check nr or receiver OR replace older file" This problem doesn't come up if I want replace old file. Sub Macro1() ActiveWorkbook.SaveAs Filename:="D:\SentInvoices\" & Range("C3").Value _ & Range("A8").Value & ".xls", _ FileFormat:=xlNormal, _ Password:="", _ WriteResPassword:="", _ ReadOnlyRecommended:=False, _ CreateBackup:=False End Sub |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Error when already same name / Macro save as cell contents
If you want to always overwrite your file, you could use:
application.displayalerts = false 'your code to save application.displayalerts = true But if you just want to check for an error: On error resume next 'your code to save if err.number < 0 then msgbox "something went wrong--name, number, permissions, ..." err.clear else msgbox "Saved!" end if NeedToKnow wrote: Hi, I'm getting back to this old question, some problems doesn't go away. I have this macro and it works fine until invoice has already been saved. First ofcourse excel wants to know if I want replace earlier file - no - next popup is "Runtime error 1004 Method 'SaveAs' of object '_Workbook' failed. How can I get excel to say for ex "file couldn't be saved, check nr or receiver OR replace older file" This problem doesn't come up if I want replace old file. Sub Macro1() ActiveWorkbook.SaveAs Filename:="D:\SentInvoices\" & Range("C3").Value _ & Range("A8").Value & ".xls", _ FileFormat:=xlNormal, _ Password:="", _ WriteResPassword:="", _ ReadOnlyRecommended:=False, _ CreateBackup:=False End Sub -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Error when already same name / Macro save as cell contents
Thank you again! This site has been a huge help in last 2 months for me.
Life would be sometimes much easier if I would be making files just for my own use. "Dave Peterson" kirjoitti: If you want to always overwrite your file, you could use: application.displayalerts = false 'your code to save application.displayalerts = true But if you just want to check for an error: On error resume next 'your code to save if err.number < 0 then msgbox "something went wrong--name, number, permissions, ..." err.clear else msgbox "Saved!" end if NeedToKnow wrote: Hi, I'm getting back to this old question, some problems doesn't go away. I have this macro and it works fine until invoice has already been saved. First ofcourse excel wants to know if I want replace earlier file - no - next popup is "Runtime error 1004 Method 'SaveAs' of object '_Workbook' failed. How can I get excel to say for ex "file couldn't be saved, check nr or receiver OR replace older file" This problem doesn't come up if I want replace old file. Sub Macro1() ActiveWorkbook.SaveAs Filename:="D:\SentInvoices\" & Range("C3").Value _ & Range("A8").Value & ".xls", _ FileFormat:=xlNormal, _ Password:="", _ WriteResPassword:="", _ ReadOnlyRecommended:=False, _ CreateBackup:=False End Sub -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Clear Contents Of Cell If Value = 0 or Error | Excel Worksheet Functions | |||
Save using Macro but test to see if an error appears on spreadshee | Excel Discussion (Misc queries) | |||
How to save file in a macro taking new name from cell contents? | Excel Discussion (Misc queries) | |||
Macro that looks at cell contents | Excel Discussion (Misc queries) | |||
Macro to remove contents of cell and move all other contents up one row | Excel Discussion (Misc queries) |