<div>
You could get hold Excel VBA Programmers Reference by Stephen Bullen, John Green, Rob Bovey &amp;&nbsp;Mike ALexander, that has an object model reference within it, a bit simpler than trying to do it on-screen.
</div>


You could get hold Excel VBA Programmers Reference by Stephen Bullen, John Green, Rob Bovey & Mike ALexander, that has an object model reference within it, a bit simpler than trying to do it on-screen.

<div>
<div class="content wysiwyg-content">
Hi Experts:<br />
<br />
&nbsp; &nbsp; I am trying to write program to work with Microsoft Excel, and I know it can work like the following:<br />
**************************<wbr />**********<wbr />**********<wbr /><br />
using Excel;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Excel.Application excel = null;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Excel.Workbook wb = null; <br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Excel.Worksheet ws = null; <br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Excel.Range rng = null;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; object missing = Type.Missing;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; excel = new Excel.Application();<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; wb = excel.Workbooks.Add(missin<wbr />g);<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ws = wb.ActiveSheet;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; rng = ws.get_Range(&quot;A1&quot;, missing);<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; rng.Value2 = &quot;Techrepublic.com&quot;;<br />
**************************<wbr />**********<wbr />**********<wbr />****<br />
<br />
However, I cannot find the complete reference of the Excel Object library even though I can find some tutorial. Do you know where is the specification of each class and member of this library? Thank you!<br />
<br />
Sui
</div>
</div>


Hi Experts:

    I am trying to write program to work with Microsoft Excel, and I know it can work like the following:
**********************************************
using Excel;
            Excel.Application excel = null;
            Excel.Workbook wb = null; 
            Excel.Worksheet ws = null; 
            Excel.Range rng = null;
            object missing = Type.Missing;
            excel = new Excel.Application();
            wb = excel.Workbooks.Add(missing);
            ws = wb.ActiveSheet;
            rng = ws.get_Range("A1", missing);
            rng.Value2 = "Techrepublic.com";
**************************************************

However, I cannot find the complete reference of the Excel Object library even though I can find some tutorial. Do you know where is the specification of each class and member of this library? Thank you!

Sui

Where to find the specification of Excel Object libarary API? (Excel 2003)

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.