En excel puede resultar más sencillo dll libraries used. One of the advantages of using these libraries is that the code within them can not be modified in any way which is useful when you already have defined the functions or subroutines that are needed inside.
dll
These libraries can be created using languages \u200b\u200bsuch as Visual Basic, Visual C + +, visual c #, etc. Using these languages \u200b\u200ballows us to create more user-friendly interfaces aids and others. To explain the use of a library, take the example of which is on the website: http://xcell05.free.fr/english/index.html . There
you can download the file
FUNCUSTOMIZE.ZIP
This zip file contains the following documents:
- Funcustomize: Help File
- Funcustomize.dll: Library where
functions - ; FunCustomize_Demo.txt:
Notepad - FunCustomize_Demo.xla: File or Excel xla addin
At this point it is important to note that the functions contained within a dll can not be called directly in excel, you need a vba excel code with which to call what is within this library.
In the library in question, the. Xla contains in its first few lines a code (press ALT + F11 to see the code) that would match a range of cells that are within a xla file sheets. To be able to see the leaves of the file. Xla, you must change IsAddin ThisWorkbook property to False.
source of the initial range is referred to "A2: Z5" I changed to "A2: Z6" to recognize the role that I've added XLSTATION and whose information is in row 6, this function is merely to multiply two numbers. The modified version you can download here.
After the function has been added, this will usually appear as all other functions and also has built-in Excel will help menu when you press fx in the formula bar. All these characteristics are obtained thanks to the code inside the dll.
I hope it served to learn more about the use of dll libraries and is useful and will serve many. I will be attentive to your inquiries.
0 comments:
Post a Comment