Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
custom error 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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
custom error message
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
custom error message
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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
custom error message
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
custom error message
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom Views Error Message | Excel Discussion (Misc queries) | |||
Custom Error Message | Excel Programming | |||
replace VBA run-time error message with custom message | Excel Programming | |||
Custom error-message for MatchRequired ComboBox | Excel Programming | |||
Why error message when trying to display custom view? | Excel Discussion (Misc queries) |