BorlandTalk.com

Sandra · Guest

Hi, I have an application which opens an excel file in an OLE
container. With a TExcelWorkbook component, I'm using :-

ExcelWorkbook1.ConnectTo(OLEContainer1.OLEObjectInterface as
_Workbook)

to get a reference to the opened workbook. However, my application
uses a number of dll's which reference the opened workbook and refer
to it via a class which stores the current excel application, the
workbook opened and the worksheet. As I cannot refer to the
TExcelApplication, TExcelWorkbook and TExcelWorksheet components from
my dll's, I need the equivalent _Application, _Workbook and _Worksheet
objects. I can use :-

aWorksheet := ExcelWorkbook1.Worksheets[1] as _Worksheet;

to get a _Worksheet object, but I also need a _Workbook and
_Application object. Is their any reliable way of getting the correct
reference to the excel application and workbook?

This area has me confused! There seem to be so many ways to connect
to an excel application, but varying between these methods causes
problems!

Thanks for any help

Sandra

Sandra Campbell · Guest

Sorry folks, have worked it out!
Just having problems with different type libraries and different versions of
Delphi!

"Sandra" <sandra.campbell (AT) ent-lib (DOT) co.uk> wrote