What are excel server components and are they distributed freely ??? 
Author Message
 What are excel server components and are they distributed freely ???

Hello All,
??? Excel is suppose to have two components, OLE Automation client and
OLE
Automation server.? When we launch Excel the GUI that comes on the
screen is
the client component.?? For all file i/o processing it should use server

component that should be present in the form of DLL or OLB files.?? Now
we are
creating an application that manipulates Excel files.? So our
application acts
a client.?? We need to figure out
1. What are those server components(may be one of the OLB files) ?
2. Are they freely distributable ?
3. How do we install them ?

Thanx
Sunil
?

  SunilRH.vcf
< 1K Download


Wed, 18 Jun 1902 08:00:00 GMT  
 What are excel server components and are they distributed freely ???
Hello Sunil,

The standard version of Excel is capable of acting as an automation server. If
you are programming it from another application, you need to create an object
variable referring to the Excel type library and you can then manipulate Excel
objects in much the same way you do from Excel.

There are no special components involved, beyond the standard Excel components.
You can't distribute any Excel components - your users must have a copy of
Excel installed,

HTH,

John Green
Sydney
Australia

Please post all replies to NewsGroups

Quote:

> Date: Thu, 02 Mar 2000 11:44:14 +0530

> Subject: What are excel server components and are they distributed freely ???
> Newsgroups: microsoft.public.excel.programming,microsoft.public.vc.mfcole

> Hello All,
> ??? Excel is suppose to have two components, OLE Automation client and
> OLE
> Automation server.? When we launch Excel the GUI that comes on the
> screen is
> the client component.?? For all file i/o processing it should use server

> component that should be present in the form of DLL or OLB files.?? Now
> we are
> creating an application that manipulates Excel files.? So our
> application acts
> a client.?? We need to figure out
> 1. What are those server components(may be one of the OLB files) ?
> 2. Are they freely distributable ?
> 3. How do we install them ?

> Thanx
> Sunil
> ?

> [Attachment decoded to FILE://\PROGRA~1\VA\Download\SunilRH.vcf]



Wed, 18 Jun 1902 08:00:00 GMT  
 What are excel server components and are they distributed freely ???
Quote:

> We need to figure out
> 1. What are those server components(may be one of the OLB files) ?
> 2. Are they freely distributable ?
> 3. How do we install them ?

I think you may have a misapprehension.

You can use Excel as an automation server.
(e.g. from Visual Basic, with a reference to the Microsoft Excel N
Object Library):
 Dim oXL As New Excel.Application
or
 Dim oXL As Object
 Set oXL = CreateObject("Excel.Application")

But this requires that the user of your application has Excel installed
on his computer.  You cannot distribute Excel.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup



Wed, 18 Jun 1902 08:00:00 GMT  
 What are excel server components and are they distributed freely ???
As a side question - when you do this (using GetObject, etc. as I am doing
just now), under what circumstances MUST Excel be running, i.e. visible on
the Taskbar. I find I can read ok from a sheet without Excel running, but
when I write to it, nothing gets written and I do NOT get an error
message!  I declare the var "wb" at the start as

Set wb = GetObject(App.Path & "\somedata.xls")

then go round doing things like

  Set ws = wb.Worksheets(strSheet)

  ws.Cells(r, c) = Name: ws.Cells(r, c + 1) = id:

where wb and ws are of type Excel.Workbook and Worksheet

The write is ok when Excel is open and running, but I'd rather - if poss -
not have it visible. If it must be visible, I suppose I could keep it
visible for a min amt of time and hide sheets....?

Any recommendations?

TIA

James.

Quote:


> > We need to figure out
> > 1. What are those server components(may be one of the OLB files) ?
> > 2. Are they freely distributable ?
> > 3. How do we install them ?

> I think you may have a misapprehension.

> You can use Excel as an automation server.
> (e.g. from Visual Basic, with a reference to the Microsoft Excel N
> Object Library):
>  Dim oXL As New Excel.Application
> or
>  Dim oXL As Object
>  Set oXL = CreateObject("Excel.Application")

> But this requires that the user of your application has Excel installed
> on his computer.  You cannot distribute Excel.

> Bill Manville
> MVP - Microsoft Excel, Oxford, England
> No email replies please - reply in newsgroup



Wed, 18 Jun 1902 08:00:00 GMT  
 
 [ 4 post ] 

 Relevant Pages 

1. I am trying to update a record, i am not using data control

2. I am attempting to change a default setting and am lost

3. Am looking for a Calandar component for Access V2

4. I am using Exchange Server and Outlook 2000 clients

5. I am attempting to add new records to a SQL Server 7 database from Microsoft

6. how to find out what jet version i am using on my iis server

7. Excel for Mac OS X I am a new user

8. Help!!I am new to excel,,,,,,

9. Resizing am Excel range?!?

10. change documents settings in word when i am in excel running a macro


 
Powered by phpBB® Forum Software © phpBB Group