Prev: newsgroups
Next: Converting a range of Excel 2003 Cells to a Single text string
From: LunaMoon on 6 Jul 2008 14:44
Hi all,

I am using VC++ to develop some XLL file for use in Excel 2003.

Of course there are bugs.

The cell display "#NUM!".

But in VC++ I've already thrown exception with error message:

if (a!=b)
throw Constructor ("a must be equal b.", "myclass")...

Why couldn't I see the error message in Excel?

Thanks!

From: FSt1 on 6 Jul 2008 14:58
hi
not sure if i'm uderstanding correctly but if a cell is displaying #NUM!,
that is the error.
what is the fomula that is generating the error.
see this site for a explination of excel formula errors.
http://www.dummies.com/WileyCDA/DummiesArticle/Deciphering-Formula-Errors-in-Excel-2000.id-33,subcat-OFFICESOFT.html

regards
FSt1

"LunaMoon" wrote:

> Hi all,
>
> I am using VC++ to develop some XLL file for use in Excel 2003.
>
> Of course there are bugs.
>
> The cell display "#NUM!".
>
> But in VC++ I've already thrown exception with error message:
>
> if (a!=b)
> throw Constructor ("a must be equal b.", "myclass")...
>
> Why couldn't I see the error message in Excel?
>
> Thanks!
>
>
From: JLGWhiz on 6 Jul 2008 15:46
Is this what you are looking for?
Sub ErrorOut()
'Code that errors
On Error GoTo Handler:
'Other code
Exit Sub
Handler:
ErrMsg = Error(Err.Number)
MsgBox "Error Is: " & ErrMsg
End Sub


"LunaMoon" wrote:

> Hi all,
>
> I am using VC++ to develop some XLL file for use in Excel 2003.
>
> Of course there are bugs.
>
> The cell display "#NUM!".
>
> But in VC++ I've already thrown exception with error message:
>
> if (a!=b)
> throw Constructor ("a must be equal b.", "myclass")...
>
> Why couldn't I see the error message in Excel?
>
> Thanks!
>
>
 | 
Pages: 1
Prev: newsgroups
Next: Converting a range of Excel 2003 Cells to a Single text string