Solved

Delphi & Excel and com & DCOM

Posted on 2003-11-04
3
331 Views
Last Modified: 2010-04-05
Hi experts

How I can with use of COM or DCOM create a relation between Delphi 6.0 and Excel then data send and receive between them.

thanks

best regards
0
Comment
Question by:fhbexpir
  • 2
3 Comments
 
LVL 6

Expert Comment

by:GloomyFriar
ID: 9680661
0
 
LVL 6

Accepted Solution

by:
GloomyFriar earned 125 total points
ID: 9680730
0
 
LVL 6

Expert Comment

by:swift99
ID: 9691757
Also, check out your VBA help in Excel.  Just remember that the examples are VB, so you need to translate them to Pascal.  For example, you need to pay attention to whether something is a function call or an array(like) dereference

In Delphi, all OLE/ActiveX automation objects are "variant".

Not too long ago I posted a lengthy example of Delphi code to build a rather complex spreadsheet.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

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…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

867 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

12 Experts available now in Live!

Get 1:1 Help Now