Trapping Error Message

H

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Case Statment in Err trapping 3
Error Trapping 3
SendMail Error Trapping 9
Multiple VByesno Message boxes no working 2
How to programmatically set Error Trapping in VBE 4
why won't this work? 3
Excel2002 & Trapping Esc key 4
Excel Providing user message when RED X clicked & properly closing application. 2

Top