|
Format, add line numbers, error handling, expose a .NET library to VBA, and number to words in Office.
http://www.codeproject.com/Articles/229280/VBAExtend
What this application does:When you write Visual Basic for application code, this add in will do the following:- Add line numbers
- Add error handler
- Expose some dot Net library to extend VBA programing
- Expose some dot Net Controls to be used in office or other com application.
- Works With VBA6 and VBA7 for both 32 and 64 bit version of Microsoft office applications
This application will expose the following functions to Excel, Access and other VBA host- Number to words converter in both English and Arabic
- MW function to calculate the molecular weight of any chemical compound.
- Desktop screen size can be known from the VBA
- Many file related function
- Clipboard functions: Clear, SetText, GetText, Ascii2Unicode & Unicode2Ascii
- Many other dot net function are exposed to VBA
What problem is solved- Visual Studio does not provide a direct wizard to create add ins for VBA, so we should add the registry Key manually.
- Support VBA7 for 64 bit version of Microsoft office applications
VBAExtendSetup.zip
(823.4 KB, 下载次数: 216)
|
|