Help. Making an XLA not having functions declared on it


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Help. Making an XLA not having functions declared on it

  1. #1
    Join Date
    Feb 2009
    Posts
    2

    Help. Making an XLA not having functions declared on it

    I hope you can help me.

    I'm trying to do this. I have an .xla working very well. It, obviously, has declared many functions I've made. But now every time I make a new function I have to update my .xla file. What I'm trying to do is to make my .xla enough intelligent to grow up and get new function wihtout changing the .xla. So I'm storing all my functions in a SQL Database with them declaration code. for Example:

    Public Function Kmovauxcruni( Unidades As Integer, Periodo As Integer)
    On Error GoTo Salir
    Kmovauxcruni = ((Unidades * Periodo) / (Unidades + Periodo)) * 0.5
    Exit Function
    Salir:
    Kmovauxcruni = 0
    End Function

    Like that, every declaration code of my functions are in the Database. So the idea to find a way to read all these declarations from database and execute them by the .xla, in order to excel can meet and evaluate my functions. So when I need to introduce a new funtion I will just have to save the code of my function in the database and the .xla will just have to read it and execute it. This way, I won't have to update and replace my .xla again. What I don't know to do is to exectue the declaration of the function on the xla.

    I know my engilsh is not the best but, I hope you can help me.

    Apologize for the inconveniences.

    Have a nice day.

  2. #2
    Join Date
    Feb 2009
    Posts
    2
    by the way is there any way to add or reference a new class to my project in running time?

    I want to make my xla references an existing and empty file (module), and with a method from xla I write in the class all definition functions stored in my database, so excel can find the definition of the functions

    Can I do this? Reference another module which is separate from the xla where the functions definitions will be?

    Apologize for the inconveniences. I really need your help

Similar Threads

  1. Extension Functions in XSLT 1.0
    By Navcon in forum XML
    Replies: 0
    Last Post: 02-11-2008, 11:00 AM
  2. Replies: 4
    Last Post: 10-27-2006, 06:14 PM
  3. Replies: 5
    Last Post: 08-15-2005, 01:52 AM
  4. virtual functions & name hiding
    By pseudo in forum C++
    Replies: 2
    Last Post: 04-04-2005, 05:16 PM
  5. Replies: 16
    Last Post: 05-26-2001, 05:09 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center