Solved

Delphi & Excel and com & DCOM

Posted on 2003-11-04
3
333 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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

The uses clause is one of those things that just tends to grow and grow. Most of the time this is in the main form, as it's from this form that all others are called. If you have a big application (including many forms), the uses clause in the in…
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 will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

816 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

8 Experts available now in Live!

Get 1:1 Help Now