Trapping Error Message

[Harn88]

Hi

I need help. I succesfully trap the error however I would like a msg box to
appear telling the user, which file the error was found.

My code:
On Error GoTo 100
100: MsgBox "Contact IS on 1300 850 669"

I don't know which function should I use to make the file that the user try
to access appear

For example the msg box would said

Contact IS on 1300 850 669 Path: G:\Finance\General\Accounting

Thank you for your help

Harn

 

[Jacob Skaria]

Try

100: MsgBox "Contact IS on 1300 850 669" & vbLF & Err.Description