ActiveX Software for Visual Basic 6/.NET, C++ 6/.NET, Delphi, Borland C++ Builder: Matrix Maths, Time Series
 
 Home   |   Products   |   Testimonials   |   Prices   |   Support   |   Contact   |   Publications   |   About   |   Buy Now
Quick Links   Home   Purchase   Support   Site Map
Products   Product Home   ActiveX/COM Components   .NET Components   .NETcf Components   Applications   Version History
Support   Support Home   FAQ   Purchase Info   Installation Help   Support Request
About Us   Company Info   Clients   Testimonials   Press Room   Reseller Info   Affiliates   Publications   Contact Us
 
   FAQ - Frequently Asked Questions
 

FAQ Home | Ask A Question FAQ Home | Ask A Question
Can I use your components directly within Excel as built-in functions?

Yes, it is possible to do this. For some components such as Options/X, we have supplied wrapper functions which enable the methods to be called directly in Excel cells.

In the Excel examples, it is shown in one of them, how to use a number of the available functions within the VBA code. That is, in the Function demo, there are a number of simple VBA wrapper functions that wrap the corresponding Options/X methods. These functions show how to effectively call the Options/X methods directly from within the cells of Excel spreadsheets like the built-in functions, however there are a few points to take into account with this approach:

  1. Not all Options/X methods may have wrapper functions written for them. However you should be easily able to extend the wrapper functions as required by checking the existing methods and functions.
  2. The true advantages of the Options/X control is more easily obtained by using the methods directly in VBA code instead of only using the function wrappers.

    The COM Add-In shows the way to use Options/X more directly within VBA code.

    If you wish to create new Excel or Access applications, take a look at the way in which the Options/X control is used within the Excel and Access demos. Full source code for each of them is included in the Demo Applications directories.
Visitor Comments
No visitor comments posted. Post a comment
Related Questions
No related questions were found.
Attachments
No attachments were found.



Search FAQ
 
 
             
[Advanced Search]


Browse by Category
 
 
User Opinions
0% 100% (1 vote)

How would you rate this answer?
Helpful
Not helpful