View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default 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