Solved

Delphi 2 and Excel 97

Posted on 1997-04-16
5
170 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
indy Tidtcpserver best  way to brodcast message to multiable clients 1 162
FMX enumerated colours 2 115
Delphi XE10 Round Image 2 154
Tidtcpserver listening on multiports? 1 35
Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

790 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