Link to home
Start Free TrialLog in
Avatar of fhbexpir
fhbexpir

asked on

Delphi & Excel and com & DCOM

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
Avatar of GloomyFriar
GloomyFriar
ASKER CERTIFIED SOLUTION
Avatar of GloomyFriar
GloomyFriar
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of swift99
swift99
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.