Using Excel TLB

Chris Snow

Delphi Developer

Tue, 15 Jan 2002 03:00:00 GMT

Using Excel TLB

Can anyone please assist me. I am trying to open an existing excel workbook
from with Delphi. How is this done, I have tried using

IExcel := Excel_TLB.CoApplication_.Create;
IExcel.Workbooks.Open ('c:\Book1.xls');

but I am not sure what other parameters I should be passing to the open
function.

Thanks in advance,

Chris Snow.

Micha3 Furma

Delphi Developer

Fri, 18 Jan 2002 03:00:00 GMT

Re:Using Excel TLB

try Excel Visual Basic help
(for Excel 97 : vbaxl8.hlp)

Quote

Chris Snow wrote:

> Can anyone please assist me. I am trying to open an existing excel workbook
> from with Delphi. How is this done, I have tried using

> IExcel := Excel_TLB.CoApplication_.Create;
> IExcel.Workbooks.Open ('c:\Book1.xls');

> but I am not sure what other parameters I should be passing to the open
> function.

> Thanks in advance,

> Chris Snow.

===========================================
Micha3 Furman
mich...@kamsoft.com.pl

Kevin Bir

Delphi Developer

Sat, 19 Jan 2002 03:00:00 GMT

Re:Using Excel TLB

Take a look at the Type Library, You will need to pass "EmptyParam" to all
parameters that you want to use the Defaults for. You are Simply not
supplying enough parameters. Excel.Workbooks.Open() Requires 17 Parameters.

Kevin

Quote

Micha3 Furman <mich...@kamsoft.com.pl> wrote in message

news:37A550CC.44553F98@kamsoft.com.pl...

Quote

> try Excel Visual Basic help
> (for Excel 97 : vbaxl8.hlp)

> Chris Snow wrote:

> > Can anyone please assist me. I am trying to open an existing excel
workbook
> > from with Delphi. How is this done, I have tried using

> > IExcel := Excel_TLB.CoApplication_.Create;
> > IExcel.Workbooks.Open ('c:\Book1.xls');

> > but I am not sure what other parameters I should be passing to the open
> > function.

> > Thanks in advance,

> > Chris Snow.

> --

> ===========================================
> Micha3 Furman
> mich...@kamsoft.com.pl

Other Threads

1. using Excel.TLB

2. General Excel TLB question

3. EXCEL TLB and language versions

4. Excel TLB Problem

5. Importing .TLB file (ACVBEXT.TLB)

6. Mapping *tlb.pas to a tlb

7. TLB Editing : Lost synchronisation with TLB.h

8. Word97 TLB combinded with Word2000 TLB

9. Excel - using Excel VBA to call functions stored in a Delphi COM Add-In

10. Exporting to Excel using OLE when Excel is Editing Cell