Error messages.

[Cyberpawz]

When I run a script I get an error message saying there in no data. Which is what I am expecting... but is there a way to make it so instead of seeing that message which will confuse non-tech people to no end for some reason.

Is there a way to change that through VBA or a setting somewhere that can be attached to the workbook so when that message comes up instead of saying error ##: no data, it will say something like "The data you are attempting to import has already been imported, there is no new data, please update the XXXX Tab and run this script again."?

Thanks.

[JosephP]

probably yes-depends on the script.

[Pulsus]

Cyberpawz,

Sorry, but when you say you are running a script you mean you are running a Macro?

If Yes you can use de ONERROR command.

[Cyberpawz]

Cyberpawz,

Sorry, but when you say you are running a script you mean you are running a Macro?

If Yes you can use de ONERROR command.

Sorry, yes a Macro... old school terminology back from the early 90s... I still lapse into it at times.

That being said, the onerror is for a blanket error... correct? Not if error 51, or error 13, etc...

[JosephP]

you can use on error resume next, then test the err.number
if you post the code we could be more specific. ;-)

[Cyberpawz]

There isn't one created yet, I'm asking because I've not seen anything like this except for the generic "canned" message.

[JosephP]

but you said you got the error when running a script?

[Cyberpawz]

but you said you got the error when running a script?

Only if nothing is transferred from one tab to another, which is an expected error.

[JosephP]

that is the code I was talking about. if you want to trap/handle/bypass the error it would help to see the code that causes it.