• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 180
  • Last Modified:

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

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!

  • 2
1 Solution
Rory ArchibaldCommented:
Using the Object Browser in the Excel VBEditor will give you a list of the properties/methods/classes and MSDN is a good resource for programming with Office and .Net: http://msdn.microsoft.com/en-us/vsto/default.aspx
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.
Rory ArchibaldCommented:
Fancy seeing you here! ;)
huangs3Author Commented:
Thank you!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now