Err.number is not working

[jaryszek]

Hi,

my code:

Please Login or Register  to view this content.

Application.ExecuteExcel4Macro(name) is hidden space variable and it s assigned with the other macro.
Here it is empty so this code will throw an error.

ipath is set as Variant/error like here:
problem.png

but Err.Number is not working.
How can I create here my error handler?

Best Wishes,
Jacek

[sandy666]

Maybe use Report Post (in your first post) to ask moderator to move your thread here: Excel Programming / VBA / Macros

[jaryszek]

If you want to use hidden space variable you can set up this as:

Please Login or Register  to view this content.

Could you please help me?

Jacek

[6StringJazzer]

Err.Number is not working

Please explain what "not working" means.

• Does the code run?
• Does it run but do nothing?
• Does it produce error messages? If so, what do the messages say?
• Does it produce unexpected/wrong results? If so, how do the results differ from what you expect?
• Does it hang?

It would help to see all of your code. To set up an error handler:

Please Login or Register  to view this content.

[xlnitwit]

Returning an error value is not the same as causing a run-time error. You need to use

Please Login or Register  to view this content.

to see if a valid value was returned. Or if you want a run-time error declare iPath as String.

[jaryszek]

Thank you !

Code is running but if this code:

name = "Path"

My whole code:

Please Login or Register  to view this content.

err.number equals "0" here and my msgbox shoule be triggered and it is not...

Thank you
Jacek

[jaryszek]

Thank you xlnitwit ! You are the boss!

Best wishes,
Jacek