Xojo Conferences
XDCMay2019MiamiUSA

Excel Exception (Real Studio network user group Mailinglist archive)

Back to the thread list
Previous thread: [ANN] CarbonDeclareLibrary update
Next thread: Re: Module Property Bug and the character of bugs


Using services   -   Jan Erik Moström <
  Excel Exception   -   mark.lubratt indeq.com

Excel Exception
Date: 28.02.04 20:24 (Sat, 28 Feb 2004 14:24:20 -0500 (EST))
From: mark.lubratt indeq.com
Hello!

I'm trying to use the Excel plugin (Windows XP, Win IDE 5.2.4, MS Office
2000) and I have the following snippet:

Sub
(a bunch of Dims and news)
.
.
.
excel.Range("A","C").ColumnWidth = "AutoFit"
.
.
.
Exception err as ExcelException
MsgBox err.message
End Sub

I'm able to send information to the Excel spreadsheet, but then I'm trying
to autofit the column widths (not sure exactly how to do this), which is
throwing an ExcelException. The problem is that it is being reported as
an unhandled exception. Eventhough I have an exception block that should
display the error message for me. I can even take out the "err as
ExcelException," which should cause all exceptions to be handled and I
still get the unhandled exception error.

2 Questions:

1. What am I doing wrong to try to catch this exception?
2. Is there a place I can go to see the API for the Excel Plugin (the
example doesn't provide a lot of information on data types, methods,
properties, etc.)?

Thanks!
Mark

- - -
Unsubscribe or switch delivery mode:
<http://support.realsoftware.com/listmanager/>

Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>