custom error message

[Fan924]

I am getting runtime error 1004 when I run a macro and.... the
imported file is to big. The error is expected.

My question, can I replace this error message with something else?
Something instructive?

 

[Dave Peterson]

On error resume next
'your line of code that may cause the error
if err.number <> then
err.clear
msgbox "some error just took place!"
end if
on error goto 0

 

[BillyBob]

Um, what do you think? Out of curiosity, what "instructive" message did you
have in mind?

BillyBob

 

[eliano]

Um, what do you think?  Out of curiosity, what "instructive" message did you
have in mind?

BillyBob







- Mostra testo citato -

Could be that this is a new technique? )
Eliano

 

[norie]

If the error is expected why don't you do something to avoid it?

Check the size of the file perhaps?

Too big - don't continue, right size - continue.

Norie