Trapping Error Message
 

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

Trapping Error Message
 

Try

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

--
Jacob


"Harn88" wrote:

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