Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Where to place On Error
Thanks JY.
I'll preserver with this error handle and hopefully get there, I think I'm putting the code to go to when there is an error in the wrong place as when I generate an error, I still see the successful process message. Thanks, Rob "JY" wrote in message ... Hi Look also in help for "On error" HTH Regards JY "JY" a écrit dans le message de ... Hi Rob Like this Sub Test on error goto myErrorHandler do mystuff exit sub myErrorHandler : if error.description = .;;;; then end sub Regards, JY "Rob" a écrit dans le message de ... Hi, I'm using the following code to open a text file and carry out minor changes within Excel. However, there have been a couple of occassions where a Run-Time error has occured and as such I need to trap the error and report that the user should start over again. Where would I place the code and what would it look like? I belive I need On Error GoTo ErrorHandler and ErrorHandler: Exit Sub but where does this go in the code below to trap any error but still allow the routine to run and display the Successful process message. Thanks, Robert Sub ImportFile() Dim WkBk As Workbook Dim fName As Variant Dim iFname As String iFname = Application.ActiveWorkbook.Name fName = Application.GetOpenFilename("Text files (*.txt),*.txt", , "Open File") Application.ScreenUpdating = False If TypeName(fName) = "Boolean" Then MsgBox "You have chosen to cancel the process!", vbExclamation, "Information" Application.ScreenUpdating = True Exit Sub End If 'Open the chosen file using the text import options below Workbooks.OpenText filename:=fName, _ Origin:=xlWindows, StartRow:=1, DataType:=xlDelimited, TextQualifier:= _ xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=True, Semicolon:=False, _ Comma:=True, Space:=False, Other:=True, OtherChar:="^", FieldInfo:= _ Array(Array(1, 9), Array(2, 9), Array(3, 1), Array(4, 4), Array(5, 2), Array(6, 1), Array(7 _ , 9), Array(8, 9)) Columns("A:D").Columns.AutoFit Range("C1").NumberFormat = "General" Range("C1").Formula = _ "=VLOOKUP(LEFT(A1,3)," + iFname + "!Database,2,FALSE)&"" ""&A1&"" W/E: ""&Text(B1,""dd-mmm-yyy"")" Range("C1").Copy Range("C1").PasteSpecial Paste:=xlValues Range("C1").Font.Bold = True Application.CutCopyMode = False Range("A1").Select ActiveCell.SpecialCells(xlLastCell).Select Selection.EntireRow.Delete Range("A1").Select Columns("A:B").EntireColumn.Delete Application.ScreenUpdating = True MsgBox "Successful process.", vbExclamation, "Information" End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can I keep a tab in place? | Excel Discussion (Misc queries) | |||
In-place CommandBar.Add run-time error | Excel Discussion (Misc queries) | |||
No place for sum | Excel Worksheet Functions | |||
Nil in Place Off #N/A | Excel Worksheet Functions | |||
1st, 2nd, 3rd Place etc..... | Excel Worksheet Functions |