Error execution Report

Hi guys,

What i'm trying to do is to have an error report when i execute my macro, i have a problem with my error report, in fact what i need to do is an inputbox where i can put the name of my Macro to execute: "Module1.MacroName" but the problem is that when i want to execute my macro it doesn't work.
here's the code:

Please Login or Register  to view this content.

I don't know where is the problem i have in the beginnig of the Macro: On Error GoTo analyse but when it enter in Test this dosen't work.

Does anyone knows how to solve this problem please.

Thanks for your help

We always need more information than "doesn't work". In what way? Errors? Does the wrong thing? Does nothing?

As an aside, you should not use On Error Goto like that - if an error occurs anywhere after your analyse: label, it will cause a run time error.

first another improvement of your code

instead of:

Please Login or Register  to view this content.

use

Please Login or Register  to view this content.

I fear that what you want to accomplish you can't.
suppose you call a macro: par example Sub tst()
if an error occurs then the code in 'tst' will return to the 'calling' macro.
In the macro Sub tst() there is a line 'On error resume next'.
The error number (err.number) will not be stored in a variable, and as soon as this macro finishes err.number is being reset (let alone that no information is available in which codeline the error took place.)
So after returning in the 'calling' macro no information is available on what happened in the macro 'tst'.
The best you could do is putting the err.number in macro 'tst' in a public variable, so that you can analyse the generated code in the calling macro, using the public variable.

I have no problems using this code:

Please Login or Register  to view this content.

prerequisite:
- sub test is a public macro
- if sub test is part of a sheetmodule you have to enter in the inputbox feuille1.test
- if sub test is part of the workbookmodule you have to enter in the inputbox Thisworkbook.test

As I mentioned earlier, if you use On Error Goto the way you are (i.e. without a Resume statement), then everything after your analyse: label is actually an error handler block, and if an error occurs in an error handler block, you get a run-time error.

The issue is the fact you are using Run. When you do that, errors in the called routine are not handled by an error handler in the calling routine.

You should have one error logging routine that you call from each of your macros, not the other way round (which makes no sense to me at all).

Something like this (untested):

Please Login or Register  to view this content.

then in your test routine:

Please Login or Register  to view this content.