View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Harn88 Harn88 is offline
external usenet poster
 
Posts: 14
Default 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