Office Programming Helper Indent VB Code 3.6
Free Version
Publisher Description
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)
About Office Programming Helper Indent VB Code
Office Programming Helper Indent VB Code is a free software published in the Basic VB VB DotNet list of programs, part of Development.
This Basic VB VB DotNet program is available in English. It was last updated on 19 March, 2024. Office Programming Helper Indent VB Code is compatible with the following operating systems: Windows, Windows-mobile.
The company that develops Office Programming Helper Indent VB Code is NewPast. The latest version released by its developer is 3.6.
The download we have available for Office Programming Helper Indent VB Code has a file size of 2.10 MB. Just click the green Download button above to start the downloading process. The program is listed on our website since 2020-02-26 and was downloaded 125 times. We have already checked if the download link is safe, however for your own protection we recommend that you scan the downloaded software with your antivirus. Your antivirus may detect the Office Programming Helper Indent VB Code as malware if the download link is broken.
How to install Office Programming Helper Indent VB Code on your Windows device:
- Click on the Download button on our website. This will start the download from the website of the developer.
- Once the Office Programming Helper Indent VB Code is downloaded click on it to start the setup process (assuming you are on a desktop computer).
- When the installation is finished you should be able to see and run the program.