Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
On Error ??
Can you have an On Error Goto ErrHandle and then once it is done handling the error resume from where the error occured
Example would be that I am copying several files to different workstations. It can't copy the file to the workstation because it is not running. This would be the error. It would then goto an error ahndle where it write this information to a log. I then want it to continue from the point that error occured TIA |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
On Error ??
On error goto ErrHandler
' code to cause an error ErrHandler: ' code to write log Resume Next End Sub -- Regards, Tom Ogilvy "Kevin" wrote in message ... Can you have an On Error Goto ErrHandle and then once it is done handling the error resume from where the error occured. Example would be that I am copying several files to different workstations. It can't copy the file to the workstation because it is not running. This would be the error. It would then goto an error ahndle where it write this information to a log. I then want it to continue from the point that error occured. TIA |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
On Error ??
Check out Resume Next in help.
-- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Kevin" wrote in message ... Can you have an On Error Goto ErrHandle and then once it is done handling the error resume from where the error occured. Example would be that I am copying several files to different workstations. It can't copy the file to the workstation because it is not running. This would be the error. It would then goto an error ahndle where it write this information to a log. I then want it to continue from the point that error occured. TIA |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
On Error ??
Kevin,
Can you have an On Error Goto ErrHandle and then once it is done handling the error resume from where the error occured. In your error handling block, use the Resume statement to resume code execution at the line of code that caused the error. Use Resume Next to resume code execution at the line following the line that raised the error. Under no circumstances use GoTo in your error handling block. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Kevin" wrote in message ... Can you have an On Error Goto ErrHandle and then once it is done handling the error resume from where the error occured. Example would be that I am copying several files to different workstations. It can't copy the file to the workstation because it is not running. This would be the error. It would then goto an error ahndle where it write this information to a log. I then want it to continue from the point that error occured. TIA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 - error saving file & error loading dll | Excel Discussion (Misc queries) | |||
Visual Basic Error Run Time Error, Type Mismatch | Excel Discussion (Misc queries) | |||
Counting instances of found text (Excel error? Or user error?) | Excel Worksheet Functions | |||
Syntax Error Runtime Error '424' Object Required | Excel Programming |