How to Write errors to log file?

[gene_sc]

Hi
Another newbe VBA question....
How can I Write errors to log file? I saw an example somewhere, but can't seem to find it
thanks
gene

 

[Colo]

Hi gene,
Please check "Resume Next" out as follows.

<pre>
Sub test()
On Error GoTo WriteLog
Cells(0, 1).Select 'Error
MsgBox "Code is still running."
Exit Sub
WriteLog:
Debug.Print Err.Number & ":" & Err.Description
Resume Next
End Sub
</pre>

HTH

 

[gene_sc]

Hi Thanks
I will try it out tonite, when I get home.
How can I set the path to save the log file?
regards gene

 

[Colo]

Hi it's me again.

<pre>
Sub test2()
On Error GoTo WriteLog
Cells(0, 1).Select 'Error
MsgBox "Code is still running."
Exit Sub
WriteLog:
' // Please write fullpath where you want to set instead of ErrorLog.txt
' // EG. C:myfolderErrorLog.txt
Open "ErrorLog.txt" For Append As #1
Print #1, Now & " " & Err.Number & ":" & Err.Description
Close #1
Resume Next
End Sub
</pre>

 

[gene_sc]

Hi Colo
Thanks :^)
I will give these a try.
I think this will help me, to learn VBA a little quicker
regards gene

 

[gene_sc]

Colo
Worked like a charm :^)
Thanks
regards gene