Log errors

[DrSmyth]

Hi, I run some scheduled tasks on my PC using excel/word and vba, that occasionally throw up an error. In order to enable the other scheduled tasks to run I get the error handler to quit the application in the event of these errors.

The problem is that I need to start logging these errors and am not sure how to do it, is there a way of generating an error log?

 

[Chance1234]

How about in your error trap, writing to a text document or a excel spreadsheet the error ?

Chance,

F, G + _HH

 

[Chance1234]

hit enter a bit too soon,

remember in your error trap you have

err.number
err.description etc

Add a time stamp and hey presto

Chance,

F, G + _HH

 

[DrSmyth]

How would you export this to a log?

 

[Chance1234]

Well,

If you were doign it to a excel file , then look at createobject
Sheet Object
Cell Reference

If you are doing it to a text file then

have a look at freefile and print


Chance,

F, G + _HH

 

[DrSmyth]

Cheers I'll take a look at these things

 

[Chance1234]

you might find the following article helpful

Chance,

F, G + _HH

 

[Chance1234]

trigger happy on the enter button today

http://www.exceltip.com/st/Log_files_using_VBA_in_Microsoft_Excel/493.html

Chance,

F, G + _HH

 

[DrSmyth]

Thanks for your help chance. I'll let you know how I get on..