Error Report

[pierre08]

Hi guys,

What i'm trying to do is to have an error report when i execute my macro, i have this code for a simple exemple:

Please Login or Register  to view this content.

In fact what i need in addition if this is to have the line number where the error was found.
Is there a code to do that?

Thanks for your help.

[romperstomper]

You can use Erl but you would need to actually add the line numbers to your code for it to work.

[pierre08]

Is there a code to add the line numbers to the code or should i do it manually??

[pierre08]

I wrote this code:

Please Login or Register  to view this content.

[DonkeyOte]

You might be interested in: http://www.mztools.com/v3/mztools3.aspx

[pierre08]

Thank youuuuu this will help me a lot thanks

[pierre08]

After i've add the lines number to my code how can i use the Erl function?
Does anyone have an exemple for that please

Thanks for your help

[DonkeyOte]

You can just Erl to tell you on which line the error occurred, eg:

Please Login or Register  to view this content.

[pierre08]

Hi guys,

i have a new 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

[romperstomper]

This is a completely different question, so I suggest you start a new one.