custom error message

  • Thread starter Thread starter Fan924
  • Start date Start date
F

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?
 
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
 
Um, what do you think? Out of curiosity, what "instructive" message did you
have in mind?

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

BillyBob







- Mostra testo citato -
Click to expand...

Could be that this is a new technique? :-))
Eliano
 
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
 
Back
Top