‘ a variation of the Split function that works with more than one separators’ note that separators can consists of 2 or more chars’ Example:’ Dim res() As String’ res()

‘ generate a random string” the mask can contain the following special chars’ ? : any ASCII character (1-127)’ # : a digit’ A : an alphabetic char’ N :

‘ Concatenate a variable number of text files into a single result file” Params:’ – ResultFile: the complete path of the result file you want to create’ – Separator: a

Private Declare Function IsCharUpper Lib “user32” Alias “IsCharUpperA” (ByVal _ cChar As Byte) As Boolean’ Check is the specified string is composed only by upper case characters (no ‘ digits

Private Declare Function IsCharLower Lib “user32” Alias “IsCharLowerA” (ByVal _ cChar As Byte) As Boolean’ Check is the specified string is composed only by lower case characters (no ‘ digits

When you use the Add-Ins project template to build your own add-ins, the description of the add-in appearing in the Add-Ins Manager window is always “My Addin.” It isn’t immediately

A pointer to member of a base class can be converted to a pointer to a corresponding member of its derived class. The opposite, however, is illegal: you cannot convert

The std::string has a data member that holds its size. Calculating the size of a string object is therefore a fast constant time operation, which is independent of the number

You can make your code more readable by always adding a remark on top of all your procedures. Create an add-in that makes it fast and easy. First, run New

Since the introduction of DHTML and client-side scripting, developing Internet applications can be a real challenge. If you don’t have the luxury of a “pure” Internet Explorer environment, there’s a

You can retrieve information about all the available drives using calls to Windows API, if you like the hard way of doing things. A much simpler solution is offered by

HTML elements can be made inactive and non-responsive by using the disable attribute. When HTML controls are disabled, they appear dimmed and don’t respond to user input. This is useful

This is achieved by using the Windows Script Host. First, create an instance of the object WScript.Shell. Then, use its Run method to execute the DOS command. For example, say

Setting Response.Expires to a negative number or 0 disables caching. Sometimes, the use of Response.Expires = -1 doesn’t work because of mismatches between the clocks on the server and the

From the command prompt, type: nbtstat -R This will reload the lmhosts file, and you won’t have to reboot the system for the changes to take affect.

Before starting, add the Microsoft DAO 3.51 Object Library Reference. Private Sub Form_Load() Dim WkSp As Workspace Dim dB As Database ‘Define the file .MDW where are the users and

You can use the ‘With … End With’ statements if you are using VBScript 5.0 or later. It helps to improve performance. This runs slower: PersonObj.FirstName = “Sandeep”PersonObj.LastName = “Gain”PersonObj.City

Oracle DBA’s can run this query to terminate sessions if users are inactive for more than certain time period for any Security/Performance reasons. select s.username “User”, s.osuser “OS User”, s.sid

Use Environ var. This Works Only on Windows NT and 2000. Me.Label1 = “Temp Dir – ” & Environ$(“temp”) Me.Label2 = “Sys Dir – ” & Environ$(“windir”) &IIf(Len(Environ$(“OS”)), “SYSTEM32”, “SYSTEM”)

MSVC has a small, but annoying bug with the scope of variables defined in “for” loops. For example, the following fragment is valid C++, but will not compile on MSVC:

Normally, when you allocate an array using new or malloc in VC++, you can only see the first element when you look at the variable in the watch window. To

Many of the C runtime functions have direct equivalents in the Win32 application programming interface (API). However, when you use C-Runtime functions, you need to have C-Runtime startup code and

Loops (for, while, do..while) are used often in code?especially nested loops. Eventually, you need to exit the loop by using a “break” statement. However, if you are inside of a

In Java, Strings are immutable objects. This means that they cannot be modified in any way after they are created. When you attempt to modify a String object, you often

For a number of reasons, you might need to write an object to a file for future usage. Perhaps your applet needs to keep some sort of “state” and between

Singletons are builder design patterns where the number of instances is limited to one (according to the Gang of Four – DesignPatterns). The most common way of implementing them is