I'm going to try to be clearer.
1) About the context :
First, it may be possible to do it in VBA. However, as i conduct many symbolic transformations, i prefer using Maple. Just to clarify again the context, the aim of the module is to calculate the inverse kinematic of a mechanism. From geometric paramaters and kinematic inputs, i calculate kinematic outputs. Currently, the process that i conduct is the followin : in a worksheet, I import some data (the kinematic inputs) from Excel. Next, I conduct my calculations in Maple and finally I export the result inside Excel (the kinematic outputs). It works fine but it is not very convenient that my calculation are not made in a kind of “real time”. Moreover, Sometime I didn’t remember on which Excel sheet I have sent my results. Consequently, I think that a solution which will be more convenient for me is to use the Excel communication. It would permit to directly analyze a result in Excel when I change some input data.
2) About the portability:
You are completely right. The portability will be limited since the user of my excel sheet should have Maple so as to use it. In my lab, we are several to use Maple and thus it will be OK. May be, another step will be to transform this module into a dll. But, let's start step by step.
3) Come back to my need :
Do you have some ideas so that I could create a package module embedding the kinematic outputs ("so to be independent, relatively portable (Maple is needed)") ?
The objective is to be able to use it directly in Excel with the Excel adding. Moreover, i would like not to make big modifications in my currently worksheet. I mean that it would be create to let the line by line code at the beginning so to be able to conduct some tests. Namely, I would like to keep the calculations of the outputs before the module.
I hope that i clarify my need.