Excel 2000 Automation

[John Spiegel]

Hi All,

Does anyone know of a site that might give some decent documentation on
Excel 2000 objects, particularly their methods and parameters, in order?
The little I've found so far seems to mainly focus on using named parameters
which doesn't do me much good in C#!

TIA,

John

[Paul Clement]

On Tue, 5 Apr 2005 07:15:55 -0600, "John Spiegel" <js******@NOSPAMc-comld.com> wrote:

¤ Hi All,
¤
¤ Does anyone know of a site that might give some decent documentation on
¤ Excel 2000 objects, particularly their methods and parameters, in order?
¤ The little I've found so far seems to mainly focus on using named parameters
¤ which doesn't do me much good in C#!
¤

The following should get you started:

http://msdn.microsoft.com/library/de...eloverview.asp

You can also learn quite a bit about how the Excel object model operates programmatically by using
the Macro Recorder in Excel.
Paul
~~~~
Microsoft MVP (Visual Basic)

[Fredrik Wahlgren]

"John Spiegel" <js******@NOSPAMc-comld.com> wrote in message
news:uO**************@tk2msftngp13.phx.gbl...

Hi All,

Does anyone know of a site that might give some decent documentation on
Excel 2000 objects, particularly their methods and parameters, in order?
The little I've found so far seems to mainly focus on using named parameters which doesn't do me much good in C#!

TIA,

John

Here's a sample that shaows how to make an add-in using C#. It doesn't tell
anything about the Excel objects. I have included acouple of URL's that you
may find useful.

http://www.exceltip.com/
http://www.mrexcel.com/
http://www.j-walk.com/ss/excel/index.htm
http://www.add-in-express.com/
http://homepages.paradise.net.nz/~robree/excel/

/Fredrik

[John Spiegel]

Thanks, Paul.

I've dabbled off and on with this in other languages and have found the
macros to be quite helpful. Of course, it would've helped had I remembered
my C# syntax so Intellisense would help me along with my biggest problem:
ordering parameters.

"Paul Clement" <Us***********************@swspectrum.com> wrote in message
news:or********************************@4ax.com...

On Tue, 5 Apr 2005 07:15:55 -0600, "John Spiegel"
<js******@NOSPAMc-comld.com> wrote:

¤ Hi All,
¤
¤ Does anyone know of a site that might give some decent documentation on
¤ Excel 2000 objects, particularly their methods and parameters, in order?
¤ The little I've found so far seems to mainly focus on using named
parameters
¤ which doesn't do me much good in C#!
¤

The following should get you started:

http://msdn.microsoft.com/library/de...eloverview.asp

You can also learn quite a bit about how the Excel object model operates
programmatically by using
the Macro Recorder in Excel.
Paul
~~~~
Microsoft MVP (Visual Basic)

[John Spiegel]

Thanks for helping direct my clicks, Fredrik.

"Fredrik Wahlgren" <fr****************@mailbox.swipnet.se> wrote in message
news:O9****************@TK2MSFTNGP14.phx.gbl...

"John Spiegel" <js******@NOSPAMc-comld.com> wrote in message
news:uO**************@tk2msftngp13.phx.gbl...

Hi All,

Does anyone know of a site that might give some decent documentation on
Excel 2000 objects, particularly their methods and parameters, in order?
The little I've found so far seems to mainly focus on using named

parameters

which doesn't do me much good in C#!

TIA,

John

Here's a sample that shaows how to make an add-in using C#. It doesn't
tell
anything about the Excel objects. I have included acouple of URL's that
you
may find useful.

http://www.exceltip.com/
http://www.mrexcel.com/
http://www.j-walk.com/ss/excel/index.htm
http://www.add-in-express.com/
http://homepages.paradise.net.nz/~robree/excel/

/Fredrik