473,320 Members | 1,958 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Excel 2000 Automation

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
Jul 21 '05 #1
4 1274
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)
Jul 21 '05 #2

"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
Jul 21 '05 #3
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)

Jul 21 '05 #4
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

Jul 21 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Benjamin | last post by:
I am making a Windows EXE (.NET Visual Basic Windows Application). I would like to make it possible to open Excel Worksheets from my EXE. This should work independent of Excel version on client...
10
by: Mark Day | last post by:
Hi All, I am using Access 2000 to generate over 40 Excel charts and pivot tables using early binding to the Excel 9.0 object library. I am finding that if I show the Excel object while processing...
11
by: Mr. Smith | last post by:
Hello all, My code can successfully open, write to, format and save several worksheets in a workbook then save it by a given name, close and quit excel. My problem is that if I try and do it...
1
by: Yakimo | last post by:
I developed an application in C# using MS Excel objects. The app works fine on the computers with Excel 2000 installed, but gives an error on computers with Excel 2002. I checked an found out that...
17
by: Mansi | last post by:
I need to do some research on how to use excel automation from c#. Does anyone know of any good books related to this subject? Thanks. Mansi
6
by: frankplank | last post by:
Hi *, I'm wondering if it is possible to create a C# object, and reference it *explicitly* in an excel document. I imagine this will be more possible if I programmatically populate the excel...
5
by: RoboSchro | last post by:
I'm building a reporting system in asp.net which needs an "export to Excel" function. We have Excel 2000 in the office. So I've added a reference to the Microsoft Excel 9.0 Object Library. Having...
9
by: hari krishna | last post by:
hi, I want to send the data from dataset information to Excel through ASP.Net. there will be no XL installed on web server. web server is win 2000 server machine. I am using visual basic code in...
3
by: Tim Marsden | last post by:
Hi, I am currently creating an instance of Excel using VB.NET Automation. dim xl as Excel.Application xl = new Excel.Application However, how can I have more control over the starting of...
4
by: =?Utf-8?B?THluZXJz?= | last post by:
Hello All, We have a VB.NET application writen using VS 2003. This application apens an excel file from a vendor, reads the data and performs whatever functions it needs. We recently upgraded our...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.