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