Solved

Delphi 2 and Excel 97

Posted on 1997-04-16
5
160 Views
Last Modified: 2010-04-04
I am having trouble accessing the Collections in Excel 97.
I can access the current object with ActiveSheet or ActiveCell but I cannot access a specific collection with
Sheets(1) or Range('A1').
I do not know if it is a Delphi or ActiveX problem.
Any help would be greatly appreciated!
0
Comment
Question by:CFantin
  • 3
5 Comments
 
LVL 1

Author Comment

by:CFantin
ID: 1335414
Adjusted points to 150
0
 
LVL 1

Author Comment

by:CFantin
ID: 1335415
Adjusted points to 180
0
 
LVL 2

Expert Comment

by:javiertb
ID: 1335416
You should try taking a look at TExcel v2.2 component at Delphi Super Page. It's also valid for Excel 97 I think.

Hope this helps
0
 
LVL 1

Author Comment

by:CFantin
ID: 1335417
I was not looking for a component but how to solve the problem.

0
 
LVL 7

Accepted Solution

by:
RBertora earned 180 total points
ID: 1335418
Hello there,

sheets[1] and range["a1"] will work,
the reason for this change is as usual microsoft is screwing
us around.......

Cheers,
Rob.

0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Suggested Solutions

Creating an auto free TStringList The TStringList is a basic and frequently used object in Delphi. On many occasions, you may want to create a temporary list, process some items in the list and be done with the list. In such cases, you have to…
Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now