Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
error control
I have just written my first VBScript/Macro that does
some cool manipulation of data. How do I get the script to exit gracefully if something is wrong, or out of place? For example: I have a button attached to this script for printing: Application.ActivePrinter = "Acrobat PDFWriter on LPT1:" ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _ "Acrobat PDFWriter on LPT1:" If I hit cancel in the print screen the script will stop and go into debug. Is there a generic script "If error then....." Thanks for the helping, Graeme |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
error control
put
on error goto CANCEL at the begining of your code then at the bottom put exit sub ' need this so if no errors program doesnt execute CANCEL CANCEL: 'Any clean up code here exit sub for more info on error checking do a search for it, i am sure there i a lot written about it. Keith www.kjtfs.com Graeme wrote: *I have just written my first VBScript/Macro that does some cool manipulation of data. How do I get the script to exit gracefully if something is wrong, or out of place? For example: I have a button attached to this script for printing: Application.ActivePrinter = "Acrobat PDFWriter on LPT1:" ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _ "Acrobat PDFWriter on LPT1:" If I hit cancel in the print screen the script will stop and go into debug. Is there a generic script "If error then....." Thanks for the helping, Graeme -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2007 Form Control/ActiveX Control font difference | Excel Discussion (Misc queries) | |||
Control Box Error | Excel Discussion (Misc queries) | |||
Error 50290: Error writing to Worksheet while using an ActiveX Control | Excel Programming | |||
webbrowser control error | Excel Programming | |||
ActiveX Error w/Calendar Control | Excel Programming |