Solved

Excel Macros via DDE

Posted on 1999-01-27
4
525 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
[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
  • 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This article will show you how to use shortcut menus in the Access run-time environment.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
This video walks the viewer through the process of creating Hyperlinks for the web and other documents. Select the "Insert" tab: Click "Hyperlink":  Type "http://" followed by a web address to reference a website or navigate to a document to ref…
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…

749 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