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" <(E-Mail Removed)> wrote in message
news:b0c95b52-034f-42ec-bd68-(E-Mail Removed)...
>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" <billy...@has.onetooth> wrote:
> Um, what do you think? *Out of curiosity, what "instructive" message did you
> have in mind?
>
> BillyBob
>
> "Fan924" <a924...@yahoo.com> wrote in message
>
> news:b0c95b52-034f-42ec-bd68-(E-Mail Removed)...
>
>
>
> >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