?
Solved

Delphi & Excel and com & DCOM

Posted on 2003-11-04
3
Medium Priority
?
342 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 6

Accepted Solution

by:
GloomyFriar earned 250 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

Introducing Priority Question

Increase expert visibility of your issues by participating in Priority Question, our latest feature for Premium and Team Account holders. Adjust the priority of your question to get emergent issues in front of subject-matter experts for help when you need it most.

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…
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…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Suggested Courses
Course of the Month14 days, 22 hours left to enroll

770 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