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



On 08/29/2010 18:41, Fan924 wrote:
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

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

BillyBob

"Fan924" wrote in message
...
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 30 Ago, 01:50, "BillyBob" wrote:
Um, what do you think? *Out of curiosity, what "instructive" message did you
have in mind?

BillyBob

"Fan924" wrote in message

...



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?- Nascondi testo citato

- Mostra testo citato -

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