Search:  
NamespacesDiscussions.NET v1.1Feedback
Jscript/ActiveXObject API Question
Messages   Related Types
This message was discovered on microsoft.public.dotnet.languages.jscript.
Responses highlighted in red are from those people who are likely to be able to contribute good, authoratitive information to this discussion. They include Microsoft employees, MVP's and others who IMHO contribute well to these kinds of discussions.
Post a new message to this list...

Carlos Pescador via .NET 247 (VIP)
I understand how I can communicate with Excel
from within a Jscript (see example below).
But where is the documentation (API) of what messages I
can send to such an instance ExcelSheet, or more general,
to any ActiveXObject?

var ExcelSheet;
ExcelApp = new ActiveXObject("Excel.Application");
ExcelSheet = new ActiveXObject("Excel.Sheet");

// Make Excel visible through the Application object.
ExcelSheet.Application.Visible = true;
// Place some text in the first cell of the sheet.
ExcelSheet.ActiveSheet.Cells(1,1).Value = "This is column
A, row 1";
// Save the sheet.
ExcelSheet.SaveAs("C:\\Temp\\TEST.XLS");
// Close Excel with the Quit method on the Application
object.
ExcelSheet.Application.Quit();

--------------------------------
From: Carlos Pescador

-----------------------
Posted by a user from .NET 247 (http://www.dotnet247.com/)

<Id>hq1ZgsUMxUeOd53VgnsTwA==</Id>
Reply to this message...
 
    
Martin Honnen
Carlos Pescador via .NET 247 wrote:

[Original message clipped]

Fire up Excel and use its help section, it has the documentation of
Excel's object model, it will show examples for VBA but of course the
object model is not depending of the scripting language, you can script
it with VBScript or JScript as well.

--

    Martin Honnen
    http://JavaScript.FAQTs.com/
Reply to this message...
 
 




Ad
MBR BootFX
Best-of-breed application framework for .NET projects, developed by Matthew Baxter-Reynolds and MBR IT
 
 Copyright © Matthew Baxter-Reynolds 2001-2008. '.NET 247 Software Development Services' is a trading style of MBR IT Solutions Ltd.
Contact Us - Terms of Use - Privacy Policy - www.dotnet247.com