OLE to Excel 97 problem?
This segment of code works with Excel Version 7 for Win 95. Can anyone
help
me understand why the last line should raise an exception when used with
Excel 97?
PROCEDURE Test;
VAR Excel : Variant;
BEGIN
Excel := CreateOleObject('Excel.Application');
Excel.Workbooks.Open (Filename:='c:\mysheet.xls', ReadOnly :=
TRUE);
Excel.Visible := TRUE;
Excel.ActiveSheet.Range('A1').Select;
Many thanks for any help.
Alan Smith
A...@cc-ltd.demon.co.uk