Software Name:
Office Programming Helper Indent VB Code
Version: 3.6
Category: Miscellaneous
Date Listed/Updated: 2020-06-14 14:24:49
File size: 2490 KB
OS: Windows 2000, Windows XP,Windows Vista, Windows 7,Windows 8,Windows 8.1,Windows 10
License: freeware Price($): 0
Author/Publisher name: NewPast NA
View Full Screenshot
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 OfficeProgrammingHelperin 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)
We have affiliation with number one software market place Share-IT\. Contact us for better pricing/customised coupon code
Use Avangate Coupoun code 548AAC3EB7 to get maximum discount. Please contact through skype: softrevu or send mail to submit@softrevu.com for better pricing
EULA
Tags: VB VBA Office Access Word Excel programming program code coding macro helper indent num
Is this software spam? Report Spam
Software removal request by publisher Removal Request
Software Review: Office Programming Helper Indent VB Code Review
For publisher: Request Software Confirmation
Software from the publisher:Office Programming Helper Indent VB Code, Molar Mass Molecular Weight Calculator,