• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 199
  • Last Modified:

Delphi 2 and Excel 97

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
CFantin
Asked:
CFantin
  • 3
1 Solution
 
CFantinAuthor Commented:
Adjusted points to 150
0
 
CFantinAuthor Commented:
Adjusted points to 180
0
 
javiertbCommented:
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
 
CFantinAuthor Commented:
I was not looking for a component but how to solve the problem.

0
 
RBertoraCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now