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
Kmovauxcruni = 0
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.
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
Last Post: 02-11-2008, 11:00 AM
By promethium in forum C++
Last Post: 10-27-2006, 06:14 PM
Last Post: 08-15-2005, 01:52 AM
Last Post: 04-04-2005, 05:16 PM
By PV in forum VB Classic
Last Post: 05-26-2001, 05:09 PM
Tags for this Thread
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL