About Office Programming Helper Indent VB Code
Indent code, add line numbers, error handling, expose a .NET library and number to words to Microsoft Word, Excel, Power Point macros writers and Access VBA code
Indent VBA code, add line numbers, error handler, number to words and expose some .NET functions and to Microsoft Word, Excel, Power Point macros writers and Access VBA code
Using this application to indent your VBA Code and add error handler:
* Install the app
* Open an Office document that contains macro and edit the macro in VBA Window it or open Microsoft Access Module.
* Write your VBA code.
* From Add-Ins menu, choose Add error handler to this file.
Using this application to expose Some .NET to your VBA code:
1- Declaring NP and Number to words Objects
* Open an Office document that contains macro and edit the macro in VBA Window it or open Microsoft Access Module
* In VBE Window Select Tools, References, Browse, then select the file OfficeProgrammingHelper.tlb from the folder OfficeProgrammingHelperbin in the application installing folder.
* In VBE Window Select Tools, References, Browse, then select the file NumberToText.tbl
* Insert the following code in a any VBA Module: Public NP As New OfficeProgrammingHelper.NP
* Now you could use the NP object in any code in your project.
2- Using NP Object
You could call the NP object in your code to use the functions
* NP.Clipboard: It is used to access computer clipboard. Example: put or get text from the clipboard with specific format, clear the clipboard or converting the text in it form or to Unicode.
You could put or get text with the following formats: Text, Unicode text, RTF, HTML.
* NP.Directory: Create, Delete, Exists, Move
* NP.File: Copy, Create, Delete, Exists, Move, Shell
* NP.Screen: CM, Height, Width, TwipsPerPixelX, TwipsPerPixelY
* NP.Text: EncodingConvert, EncodingConvertByCodePage, GetTextHeight, Md5Hash, TrimAny
* NP.SQL
* NP.Colors related function to get brightness, Y and L value of RBG color or image
* NP.MW function to calculate the molecular weight of any chemical compound
3- Number to exmple:
Dim c As New NumberToArabicWords
Debug.Print(c.ConvertToWords(101)
Previous Versions
Here you can find the changelog of Office Programming Helper Indent VB Code since it was posted on our website on 2019-12-03 14:42:25.
The latest version is 3.6 and it was updated on 2024-04-22 13:36:07. See below the changes in each version.
Office Programming Helper Indent VB Code version 3.6
Updated At: 2020-02-26
Office Programming Helper Indent VB Code version 3.5
Updated At: 2019-08-19
Changes: Minimize some system requirement
Disclaimer
External Download
We do not host Office Programming Helper Indent VB Code on our servers. We did not scan it for viruses, adware, spyware or other type of malware. This app is hosted by the software publisher and passed their terms and conditions to be listed there. We recommend caution when installing it.
The external download link for Office Programming Helper Indent VB Code is provided to you by apps112.com without any warranties, representations or guarantees of any kind, so access it at your own risk.
If you have questions regarding this particular app contact the publisher directly. For questions about the functionalities of apps112.com contact us.
