Solved

Excel Macros via DDE

Posted on 1999-01-27
4
522 Views
Last Modified: 2012-05-04
Can anyone shed some light on the CREATE.OBJECT macro available in Excel, I'm building my spreadsheet programmatically from Delphi via DDE and can't seem to add any option buttons using the CREATE.OBJECT macro detailed in the XLMACR8.HLP file.  Basically, I'd like 3 options and clicking on each of the items puts a specific value in a specific cell, ie. value 20 if option 1 clicked, value 40 if option 2 clicked and value 98 if option 3 clicked.
0
Comment
Question by:Dazza051197
  • 4
4 Comments
 
LVL 44

Expert Comment

by:bruintje
ID: 1616028
Hi Dazza,

You could start here a for an overview of DDE and Excel
http://inet.uni-c.dk/~chlor/ndde/netdde.htm#clientxl
there is even a litle Delphi example,

here is an example how to start a DDE session, getting an object
http://premium.microsoft.com/msdn/library/conf/html/sa3dc.htm
 
and take a look here on how to run a macro in an Excel sheet.
http://premium.microsoft.com/msdn/library/officedev/office/output/f1/d4/s5a9b6.htm

an overview and sort of comparison of DDE and OLE
http://premium.microsoft.com/msdn/library/officedev/project/project/pssvba/mod3les4.htm

I would always choose for an OLE Automation solution, especially when you working with another language then one of the VB dialects. OLE or COM is a little more in depth stuff but when it does what you want it to do (automation is a simple application of COM) it's easy and flexible.

A good starting point on OLE Automation from Delphi you can find here
http://www.inprise.com/delphi/papers/microexcel/
It's not good but excellent, from simple automation to very complex structures.

Hope this will give you a start, enjoy and learn,
:O)Always happY.



0
 
LVL 44

Accepted Solution

by:
bruintje earned 100 total points
ID: 1616029
Hi Dazza,

You could start here a for an overview of DDE and Excel
http://inet.uni-c.dk/~chlor/ndde/netdde.htm#clientxl
there is even a litle Delphi example,

here is an example how to start a DDE session, getting an object
http://premium.microsoft.com/msdn/library/conf/html/sa3dc.htm
 
and take a look here on how to run a macro in an Excel sheet.
http://premium.microsoft.com/msdn/library/officedev/office/output/f1/d4/s5a9b6.htm

an overview and sort of comparison of DDE and OLE
http://premium.microsoft.com/msdn/library/officedev/project/project/pssvba/mod3les4.htm

I would always choose for an OLE Automation solution, especially when you working with another language then one of the VB dialects. OLE or COM is a little more in depth stuff but when it does what you want it to do (automation is a simple application of COM) it's easy and flexible.

A good starting point on OLE Automation from Delphi you can find here
http://www.inprise.com/delphi/papers/microexcel/
It's not good but excellent, from simple automation to very complex structures.

Hope this will give you a start, enjoy and learn,
:O)Always happY.



0
 
LVL 44

Expert Comment

by:bruintje
ID: 1616030
WOW! same minute.
Oke if you have any questions I'll be glad to help.
0
 
LVL 44

Expert Comment

by:bruintje
ID: 1616031
Hi Dazza,

Did it do any good?
:O)
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Have you ever had the experience that you had to follow 10 steps over and over again every time when you need to nicely forward an important email to your manager? Fear no more! With the help of the Quick Steps feature in Outlook 2010, your old chor…
Outlook Free & Paid Tools
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

821 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