Question: Toward a portable module for using in Excel Addin


In my worksheet (dedicated to the calculations of mechanism geometry), i'm trying to have a more "POO" approach (Programming Oriented Object).

In this sense, I begin to get more familiar with module and package. Attached, you can find a worksheet which gives the idea of the structure of my code. With this code, the module is very useful for me to call some results (attributes in terms of POO).

My way of doing is :
1) at the beginning, i use Maple as a calculator that is to say that at each prompt, i calculate expressions.
2) i try to make modules so as to have a easier access to the data that I calculated.

However, as the definition of the expressions that I calculated are outside my module (for example, in the worksheet attached, i calculate the expression of Gamma and psi before in my worksheet and i retrieve these expressions in the module with "global"), i can not use this module independently of this worksheet and namely in a Excel Addin.

In fact, the module works if the worksheet has been launched one time and consequently the expression of psi and Gamma are in the kernel (or in memory i want to say).


How can I do to transform my module in a independent and thus portable module ?

One idea will be to copy/ paste all the geometric calculations which have been done line by line inside the module.
However, i have many lines in separated prompts and moreover, it is always convenient to keep the line by line approach in the worksheet to make some tests.

I look forward to hearing your tips.

Thanks a lot for your help



Please Wait...