Christopher Greaves

Home

Contact Me

ON LINE STORE

ON LINE STORE

ON LINE STORE

ON LINE STORE

TorontoVBA.COM

UW.DOT (Word utility functions)

UX.XLA (Excel utility functions)

Covers For Stores

Communicating Data Between Excel And Word

List Numbering In Word

A Means Of Implementing “Undo” On GUI Forms

If you are interested in applications please visit www.VBASolutions.ca .

If you are interested in end-user macros please visit www.TorontoMacros.com .

Utility functions for Word 2000 and later versions

Please download the free utilities for Word 2000/VBA and unzip the file to a fresh folder

Then read How To Use UW.dot

Module name

Procedure name

Arguments

Result type

Description

Browsers

strBrowseFile

strPrompt As String, Optional strNameFilter

Browsers

strBrowseFile2

strPrompt As String, strNameFilter As String, strInitialDrive As String

Browsers

Browsers

strBrowseFolder

strTitle As String, Optional strRoot As String

STRING

Browsers

strCheckList

ByVal strList As String, strDelimiter As String

STRING

Browsers

strSampleFilter

STRING

DriveMapping

GetUNCPath

DriveLetter As String

STRING

DriveMapping

MapDrive

sDrive, sPath

DropDownListBoxes

blnDeleteToolbar

strToolbar As String

BOOLEAN

DropDownListBoxes

boolCreateToolbar

strToolbar As String

BOOLEAN

DropDownListBoxes

Captioner

strApplication As String, strMenuBar As String, strCaption As String, strMacro As String, strToolTip As String

DropDownListBoxes

intAddDropdown

strMenuItem As String, strCaption As String, strItem As String

INTEGER

DropDownListBoxes

lngCountToolbar

ByVal strToolbar As String

LONG

DropDownListBoxes

lngDropList

strMenuItem As String, ByVal strCaption As String

LONG

DropDownListBoxes

lngMacroButton

strMenuItem As String, ByVal strCaption As String

LONG

DropDownListBoxes

strAddDropdown

strMenuBar As String, strCaption As String, strMacro As String, strToolTip As String

STRING

DropDownListBoxes

strAddMacroButton

strMenuItem As String, strCaption As String, strMacro As String, strToolTip As String, lngFaceId As Long

STRING

modPrinters

CheckPrinter

PrinterName As String

STRING

modPrinters

CheckPrinterStatus

PI2Status As Long

STRING

modPrinters

GetString

ByVal PtrStr As Long

STRING

modPrinters

Printers

COLLECTION

modPrinters

strGetPrinterPort

strPrinter As String

STRING

modPrinters

StripNulls

OriginalStr As String

STRING

Module1

blnNeitherIn

ByVal str1 As String, ByVal str2 As String, Optional blnCaseSensitive

BOOLEAN

Module1

ClearAttributeBitsFile

filespec, lngTargetAttributeBits As Long

Module1

ClearAttributeBitsFolder

filespec, lngTargetAttributeBits As Long

Module1

lngClearBitMask

lngMask As Long, lngBits As Long

LONG

Module1

lngFilesInFolder

strFolder As String

LONG

Module1

lngFoldersInFolder

strFolder As String

LONG

Module1

lngFoldersOrFilesInFolder

strFolder As String

LONG

Module1

ReduceFileSize

strFileName As String, lngMaxSize As Long, sngPcentNewSize As Single

Module1

SetReadOnlyOFF

strFileName As String

Module1

strBrowseForFolder

Optional Title As String = "Select a folder", Optional Rootfolder As Variant

STRING

Module1

strUniqueFileName

strFullName As String, strFormat As String

STRING

modUtilities

AllFoldersInTree

strRootFolder As String

STRING

modUtilities

AllFoldersInTree_String

strRootFolder As String, Optional fCalledBySelf As Boolean

STRING

modUtilities

blnCheckForPreviousInstance

strTaskName As String

BOOLEAN

modUtilities

CleanUpParagraphs

doc As Document

modUtilities

strApplication

doc As Document

STRING

modUtilities

strLocateFilesInTree

strRootFolder As String, Optional strFilespec As String = "*.*", Optional fConfirm As Boolean = True

STRING

modUtilities

strVersionPlease

doc As Document

STRING

modUtilities

strWords

ByVal strText As String, ByVal lngWords As Long

STRING

NetWorkPaths

blnPathIsLocalPath

ByVal sPath As String

BOOLEAN

NetWorkPaths

EnumShares

shi() As SHARE_INFO_2, Optional ByVal Server As String = ""

LONG

NetWorkPaths

IsWin95

BOOLEAN

NetWorkPaths

IsWinNT

BOOLEAN

NetWorkPaths

strMapFolderToUNC

ByVal filespec As String

STRING

NetWorkPaths

strPathToDriveMap

strNetworkPath, strPassWord

STRING

NetWorkPaths

strPathToDriveUnMap

strTempDriveLetter As String

STRING

PassWMacros

strPasswordOfTheDate

dt As Date

STRING

PassWMacros

strPasswordOfTheDay

Optional lng As Long

STRING

PassWMacros

strPasswordOfTheTime

Optional lng

STRING

States

strValidatePathString

ByVal strPathIn As String, strValid As String, strDelimiter As String

STRING

UT_ARRAYS

AddToSortedArray

strAr() As String, lngIn As Long, strText As String

UT_ARRAYS

blnLoadUnique

ByRef strAr() As String, ByVal strText As String, ByVal blnCaseSensitive As Boolean

BOOLEAN

UT_ARRAYS

DeleteFromArray

strAr() As String, strText As String

UT_ARRAYS

lngIndexInSortedArray

strAr() As String, lngLow As Long, lngHigh As Long, strText As String

LONG

UT_ARRAYS

lngStringInArray

strAr() As String, strCaption As String, Optional strCaption2

LONG

UT_ARRAYS

lngStringInArrayColumn

strAr() As String, intColumn As Integer, strCaption As String

LONG

UT_ARRAYS

lngStringInVector

strAr() As String, strCaption As String

LONG

UT_ARRAYS

LoadArrayFromFile

strFile As String, strAr() As String, Optional blnUpperCase

UT_ARRAYS

LoadCodeArrayFromFile

strCodedFileName As String, strAr() As String

UT_ARRAYS

LoadDelimitedStringToArray

strFileName As String, strSection As String, strAr() As String, ByVal strIn As String, strDelimEnd As String

UT_ARRAYS

LoadToArray

strAr() As String, strText As String, blnUnique As Boolean

UT_ARRAYS

ReadArray

strFile As String, strAr() As String

UT_ARRAYS

RotateArrayElements

strIK() As String, intBefore As Integer

UT_ARRAYS

SortRedimArray

strList() As String, ByVal lLbound As Long, ByVal lUbound As Long, ByVal blnCaseSensitive As Boolean, intColumn As Integer

UT_ARRAYS

SortRedimArrayDown

strList() As String, ByVal lLbound As Long, ByVal lUbound As Long, ByVal blnCaseSensitive As Boolean, intColumn As Integer

UT_ARRAYS

SwapREDIMRows

strList() As String, lngCurLow As Long, lngCurHigh As Long

UT_ARRAYS

SwapRows

strList() As String, lngCurLow As Long, lngCurHigh As Long

UT_ARRAYS

SwapRowslng

strList() As Long, lngCurLow As Long, lngCurHigh As Long

UT_ARRAYS

UniquifyStringArray

ByRef InputArray() As String, ByRef UniqueArray() As String

LONG

UT_ARRAYS

WriteArray

strFile As String, strAr() As String

UT_Autos

ExpiredTest

dt As Date

UT_Booleans

blnAllNext

str As String

BOOLEAN

UT_Booleans

blnAlphaOnly

strIn As String

BOOLEAN

UT_Booleans

blnChar

intFile As Integer, strText As String, locStart

BOOLEAN

UT_Booleans

blnDigitsOnly

strIn As String

BOOLEAN

UT_Booleans

blnEQ

str1 As String, str2 As String

BOOLEAN

UT_Booleans

blnFieldExists

strFieldCode As String

BOOLEAN

UT_Booleans

blnFindFirstOccurrence

strFind As String

BOOLEAN

UT_Booleans

blnFindNextOccurrence

strFind As String

BOOLEAN

UT_Booleans

blnFindPreviousOccurrence

strFind As String

BOOLEAN

UT_Booleans

blnFindSelection

strText As String, blnCaseSensitive

BOOLEAN

UT_Booleans

blnGrammar

strText As String

UT_Booleans

blnGT

str1 As String, str2 As String

BOOLEAN

UT_Booleans

blnHex

intFile As Integer, strText As String, locStart

BOOLEAN

UT_Booleans

blnHideAlerts

BOOLEAN

UT_Booleans

blnIsWordLoaded

BOOLEAN

UT_Booleans

blnLT

str1 As String, str2 As String

BOOLEAN

UT_Booleans

blnMaskCompare

strMask As String, strCandidate As String

BOOLEAN

UT_Booleans

blnMaskCompareAt

strMask As String, strCandidate As String, ByVal lngC As Long

BOOLEAN

UT_Booleans

blnMatchWords

str1 As String, str2 As String, strDelim As String

UT_Booleans

blnMouse

UT_Booleans

blnOnlyWhiteSpace

strFileName As String, strSection As String, strIn As String

BOOLEAN

UT_Booleans

blnReadArray

strFileName As String, strAr() As String

UT_Booleans

blnSetScreen

boolTo

BOOLEAN

UT_Booleans

blnShowAlerts

BOOLEAN

UT_Booleans

blnSkip

m As Long, n As Long, blnRand As Boolean

UT_Booleans

blnStringInColumn

strArray() As String, lngColumn As Long, strCaption As String

BOOLEAN

UT_Booleans

blnValidatePassword

strPrefix As String

BOOLEAN

UT_Booleans

blnWP51Doc

strFile As String

BOOLEAN

UT_Booleans

blnWriteArray

strFileName As String, strAr() As String

UT_Booleans

boolAllNext

str As String

BOOLEAN

UT_Booleans

lngGetBits

strValue As String, bln As Boolean, lngItem As Long

LONG

UT_Booleans

lngGetSetBits

strValue As String, bln As Boolean, lngItem As Long

LONG

UT_Booleans

lngHexToLong

ByVal strText As String

LONG

UT_Booleans

LoadBits

strAttributes As String, lngBits As Long, bln As Boolean

UT_Booleans

LoadSetBits

strAttributes As String, lngBits As Long, bln As Boolean

UT_ClipBoard

ActiveScreenToClipboard

Copies the entire screen to the clipboard. This is the programmed equivalent of the PrtScr key on your keyboard.

UT_ClipBoard

ActiveWindowToClipboard

UT_ClipBoard

lngClipboard

LONG

UT_ClipBoard

strAppendToClipboard

strSelected As String

STRING

UT_ClipBoard

strClearClipboard

STRING

UT_ClipBoard

strLoadToClipboard

strSelected As String

STRING

UT_COMBOs

InitCmb

strFileName As String, strSection As String, cmb As ComboBox, strTag As String

UT_COMBOs

LoadArrayToComboBox

strAr() As String, intc As Integer, cmb As ComboBox

UT_COMBOs

LoadArrayToComboBox1

strAr() As String, intc As Integer, cmb As ComboBox

UT_COMBOs

SetCmb

cmb As ComboBox, strIn As String

UT_COMBOs

SortComboBox

lb As ComboBox, intCol As Integer, Optional blnNoDuplicates

UT_COMBOs

strCmb

cmb As ComboBox

STRING

UT_DPNE

blnDPNELegalForm

ByVal strIn As String, strDrive As String, strAr() As String, strName As String, strExtent As String, Optional blnFolderOption

BOOLEAN

UT_DPNE

SplitToNE

ByVal strAr As String, strName As String, strExtent As String

UT_DPNE

strBreakFileString

strFileName As String, intType As Integer

STRING

UT_DPNE

strBuildPathAndName

strFileName As String

UT_DPNE

strExtractDrivePath

sPath As String, sSeparator As String

STRING

UT_DPNE

strExtractNameExtent

sPath As String, sSeparator As String

STRING

UT_DPNE

strFixPath

ByVal strPath As String

STRING

UT_DPNE

strGetDrive

strIn As String

STRING

Returns the Drive portion of a filename string, without the path, name or extent portions.

UT_DPNE

strGetDrivePath

strIn As String

STRING

Returns the Drive and path portion of a filename string, without the name or extent portions.

UT_DPNE

strGetDrivePointers

strIn As String, intDS As Integer, intDE As Integer, intPS As Integer, intNS As Integer, intES As Integer

STRING

UT_DPNE

strGetExtent

strIn As String

STRING

Returns the Extent portion of a filename string, without the drive, path or name portions.

UT_DPNE

strGetExtentPointers

strIn As String, intNE As Integer, intES As Integer, intEE As Integer

STRING

UT_DPNE

strGetFullName

strFile As String

STRING

UT_DPNE

strGetLeaf

strFullFileName As String, strDelimiter As String

STRING

UT_DPNE

strGetLocalName

strFile As String

UT_DPNE

strGetName

strIn As String

STRING

Returns the Name portion of a filename string, without the drive, path or extent portions.

UT_DPNE

strGetNameExtent

strIn As String

STRING

UT_DPNE

strGetNamePointers

strIn As String, intPE As Integer, intNS As Integer, intNE As Integer, intES As Integer, intEE As Integer

STRING

UT_DPNE

strGetPath

strIn As String

STRING

Returns the Path portion of a filename string, without the drive, name or extent portions.

UT_DPNE

strGetPathPointers

strIn As String, intPS As Integer, intPE As Integer, intNS As Integer, intES As Integer

STRING

UT_DPNE

strGetPointers

strIn As String, intDS As Integer, intDE As Integer, intPS As Integer, intPE As Integer, intNS As Integer, intNE As Integer, intES As Integer, intEE As Integer

UT_DPNEUNC

strUNCGetDrive

strIn As String

STRING

Returns the Drive portion of a Universal Naming Convention (UNC) filename string, without the path, name or extent portions.

UT_DPNEUNC

strUNCGetPath

strFullName As String

STRING

Returns the Drive portion of a Universal Naming Convention (UNC) filename string, without the path, name or extent portions.

UT_DPNEUNC

strUNCMakePath

ByVal strPath As String

STRING

UT_EMail

CloseMessenger

objSession As Object

UT_EMail

SendDocumentAsAttachment

strTo As String, strSubject As String, strFullName As String, strBody As String

UT_EMail

SendMail

sProfile As String, sEmail As String, sText As String, sSubj As String, strItemNum As String, strTitle As String

UT_Environment

strApplicationName

doc As Document

STRING

UT_Environment

strEnvironmentFactual

doc As Document

STRING

UT_Environment

strEnvironmentPath

doc As Document

STRING

UT_Files

AMLog

doc As Document, strText as String, blnMsgBox as Boolean, blnDebug as Boolean

See Logging ; Issues a time-stamped message to the application’s log file. Optionally issues the same message to a pop-up box. Optionally delivers the same message to the debug window (in VBE View, Immediate)

UT_Files

ArrayFromFileRead

strAr() As String, strFileName As String

UT_Files

ArrayFromFileWrite

strAr() As String, strFileName As String

UT_Files

blnFile1MoreCurrent

strFile1 As String, strFile2 As String

BOOLEAN

UT_Files

blnFileExists

strFileName

BOOLEAN

UT_Files

blnFileIsWord

strName As String

BOOLEAN

UT_Files

blnFileLocked

strFileName As String

BOOLEAN

UT_Files

blnFolderExists

strFolderName

BOOLEAN

UT_Files

blnInsertFile

doc As Document, strFileName As String, strLink As String

UT_Files

blnIsShortcut

strFileName As String

BOOLEAN

Returns TRUE if the filename refers to a standard Windows XP shortcut link.

UT_Files

blnValidateDrive

ByVal strDrive As String, Optional blnLoaded As Boolean = True

BOOLEAN

UT_Files

BuildPath

Path As String, file As String

STRING

UT_Files

CopyFile

strFileName As String, strSection As String, ByVal strSourcePath As String, strName As String, strTargetPath As String

UT_Files

CreateFileList

StartDir As String, strAr() As String

UT_Files

GetFolderItems

folder As String, strAr() As String

UT_Files

KillFile

strFileName As String, Optional strPrompt As String = ""

UT_Files

LogFile

strFile As String, strMsg As String

See Logging ;

UT_Files

PrintFile

strFile As String, strMsg As String

See Logging ;

UT_Files

PutFileData

strFileName As String, strData As String

STRING

UT_Files

strGetDrives

strFileName As String, strSection As String, Optional strIn As String = "c", Optional blnLoaded As Boolean

STRING

UT_Files

strGetFileData

strFileName As String, Optional lngLength

STRING

UT_frm

strPassWord

dt As Date

STRING

UT_Fun4x

cmdCaptionsClick

frmMe As UserForm

UT_Fun4x

cmdColoursClick

frmMe As UserForm

UT_Fun4x

cmdFontsClick

frmMe As UserForm

UT_Fun4x

cmdIconsClick

frmMe As UserForm

UT_Fun4x

UserFormInitialize

doc As Document, frmMe As UserForm

UT_INTERNET

blnOnline

BOOLEAN

UT_INTERNET

WebJump

strCaption As String

UT_kernel32

KevinTimer2

UT_kernel32

Sleeper

sngSeconds As Single

UT_kernel32

varListPrinters

VARIANT

UT_lng

lngFirst

lngStart, blnIs, strIn, strSet

UT_lng

lngMin

lng1 As Long, lng2 As Long

LONG

UT_Locker

blnRunTime

strFileName As String, strSection As String

BOOLEAN

UT_Locker

dblDRIVEPercentFree

drvPath

DOUBLE

UT_Locker

dblDRIVEShowFreeSpace

drvPath

DOUBLE

UT_Locker

dblDRIVEShowTotalSize

drvPath

DOUBLE

UT_Locker

LoadPassKeyToIni

strFileName As String, strSection As String

UT_Locker

strAvailableDrives

STRING

UT_MACROS

ResetIni

strApplication As String

UT_MACROS

strDisplaySystemInfo

STRING

UT_MACROS

strShowCursor

STRING

UT_OFL

GetFolder

Optional Title As String = "Select a Folder", Optional Rootfolder As Variant

STRING

UT_OFL

ShowFileOpenDialog

ByRef FileList As Collection

UT_Printing

blnTestPDFDistiller

UT_Printing

strSetPrinter

strPrinter

STRING

UT_Printing

varGetBinNames

VARIANT

UT_Printing

varGetBinNumbers

VARIANT

UT_ProfileStrings

ResetEnvironment

strAp As String, strSection As String

UT_ProfileStrings

strBuildEnvFile

strFileName As String

STRING

UT_ProfileStrings

strCreateKeyString

strKeyName As String, strKeyValue As String

STRING

UT_ProfileStrings

strCreateSectionHeader

strSectionName As String

STRING

UT_ProfileStrings

strGetEnvVar

ByVal strFile As String, ByVal strSection As String, strKey As String, strValue As String

UT_ProfileStrings

strGetNamedKeyOfSection

strSectionData As String, strKeyName As String, lngKeyStart As Long, lngKeyEnd As Long

STRING

UT_ProfileStrings

strGetNextKeyFromSection

strSectionData As String, lngKeyStart As Long, lngKeyEnd As Long

STRING

UT_ProfileStrings

strGetNextSection

strFileData, lngStart As Long, lngSectionHeaderStart As Long, lngSectionHeaderEnd As Long, lngSectionEnd As Long

STRING

UT_ProfileStrings

strGetNextSectionFromFile

strFileData As String, lngSectionStart As Long, lngSectionEnd As Long

STRING

UT_ProfileStrings

strINIFileName

Optional strAp

STRING

UT_ProfileStrings

strMaintainKeyInSection

strSectionData As String, strKeyData As String, lngKeyStart As Long, lngKeyEnd As Long

STRING

UT_ProfileStrings

strMaintainSectionInFile

strFileData As String, strSectionData As String, lngSectionStart As Long, lngSectionEnd As Long

STRING

UT_ProfileStrings

strNameOfKey

strSectionData As String, lngKeyStart As Long, lngKeyEnd As Long

STRING

UT_ProfileStrings

strNameOfSection

strFileData As String, lngSectionStart As Long, lngSectionEnd As Long

STRING

UT_ProfileStrings

strProfileIn

strFile As String, strSection As String, strKey As String, strValue As String

STRING

UT_ProfileStrings

strProfileOut

strFile As String, strSection As String, strKey As String, strValue As String

STRING

UT_ProfileStrings

strPutEnvVar

ByVal strFile As String, ByVal strSection As String, strKey As String, strValue As String

UT_ProfileStrings

strValueOfKey

strSectionData As String, lngKeyStart As Long, lngKeyEnd As Long

STRING

UT_ShellFunctions

lngTallyPrograms

ByRef strEXEName As String

LONG

UT_ShellFunctions

Shortcut

UT_ShellFunctions

Shortcut _

Filename As String, Target As String, Optional strIconImage As String, Optional strWorkDir As String, Optional lngWindowStyle As Integer = vbNormalFocus, Optional strDescr As String

BOOLEAN

UT_SORTing

BuildKeyString

strAr() As String, strKI() As String, iK As Integer, blnCS

UT_SORTing

QCSort

strList() As String, ByVal lLbound As Long, ByVal lUbound As Long, ByVal blnCaseSensitive As Boolean, intColumn As Integer

UT_SORTing

QCSortlng

strList() As Long, ByVal lLbound As Long, ByVal lUbound As Long, ByVal blnCaseSensitive As Boolean, intColumn As Integer

UT_SORTing

QSort

strList() As String, ByVal lLbound As Long, ByVal lUbound As Long, ByVal blnCaseSensitive As Boolean

UT_SORTing

SortKI

strAr() As String, ByVal lLbound As Long, ByVal lUbound As Long

UT_SORTing

SortStringArray

strAr() As String, strCR() As String, Optional ByVal strKeys As String, Optional blnCS, Optional blnSQ

UT_SORTing

strSort

strList() As String, boolCaseSensitive As Boolean, ByVal lLbound As Long, ByVal lUbound As Long

UT_Soundex

cf_ApplySoundex

ByVal psSearchFor As String

STRING

UT_Soundex

cf_GetCharValue

ByVal pvChar As Variant

INTEGER

UT_Soundex

cf_SoundexLong

ByVal varText As Variant, Optional blnShort

STRING

UT_Soundex

cf_SoundexMatch

UT_STACKs

Stack_Init

UT_STACKs

Stack_Pop

UT_STACKs

Stack_Preserve

strAr() As String

UT_STACKs

Stack_Push

ByVal strValue

UT_strINGS

blnIAmAtHome

UT_strINGS

CheckVersion

doc As Document

UT_strINGS

FindString

intLoc() As Integer, str1 As String, str2 As String

UT_strINGS

intAllIgnore

strAr() As String, strText As String

INTEGER

UT_strINGS

intAllText

strAr() As String, strText As String

INTEGER

UT_strINGS

lngCountIn

strIn As String, strCharacters As String

LONG

UT_strINGS

lngCountOut

strIn As String, strCharacters As String

LONG

UT_strINGS

lngInStrRev

strSource As String, strSought As String

LONG

UT_strINGS

lngStringContains

strText As String, ByVal strGoal As String

LONG

UT_strINGS

MyUCase

str As String, blnCS As Boolean

UT_strINGS

Replacer

rng As Range, strFind As String, strReplace As String, Optional blnMatchCase, Optional blnWholeWord, Optional blnPrompt

UT_strINGS

strAllBut

strIn As String, I As Integer

STRING

UT_strINGS

strAllNext

strNow As String, strSet As String, intLen As Integer

UT_strINGS

strAlphaDigitsOnly

strIn As String

STRING

UT_strINGS

strAlphaOnly

strIn As String

STRING

UT_strINGS

strBinaryFromChar

ByVal strChar

STRING

UT_strINGS

strBinaryFromLong

ByVal lng As Long

STRING

UT_strINGS

strBumpUpName

strMName As String, strMyStr As String

STRING

UT_strINGS

strCharFromBinary

ByVal strBinary As String

UT_strINGS

strCharsFromDigit

strDigit As String

STRING

UT_strINGS

strCheckBuild

lng1 As Long, lng2 As Long, lng3 As Long

STRING

UT_strINGS

strCode

ByVal strSource As String, strASCIIEscape As String

STRING

UT_strINGS

strConvChars

ByVal strIn As String

STRING

UT_strINGS

strDateConst

STRING

UT_strINGS

strDateGetM

lng As Long, ParamArray strAr() As Variant

UT_strINGS

strDateGetMonth

lngMonth As Long, strLanguage As String, ParamArray strAr() As Variant

STRING

UT_strINGS

strDateLanguageDate

dt As Date, strType As String

STRING

UT_strINGS

strDateTime

Optional dtMine

STRING

UT_strINGS

strDigitsOnly

strIn As String

STRING

UT_strINGS

strEncodeAs

strIn As String, strKey As String

STRING

UT_strINGS

strFirstAlphaString

strIn As String

STRING

UT_strINGS

strFmtDec

lngValue, Optional intPlaces As Integer = 0

STRING

UT_strINGS

strGenerateNewFilename

strMyPath As String, strMyName As String, strMyExtent As String, strMyLag As String

STRING

UT_strINGS

strGenerateTag

strContainer As String, strIn As String, strAlphabet As String

STRING

UT_strINGS

strGeneric

ByVal strIn As String, strFind As String, strReplace As String

STRING

UT_strINGS

strGetArgs

ByVal strIn, strDelimOpen, strDelimClose

STRING

UT_strINGS

strGetString

strSource As String, lngPointer As Long, strDelimiter As String, intOffset As Integer, strSeparator As String

UT_strINGS

strGetSub

ByVal str As String, ByVal intPos As Integer, strDelim As String

STRING

UT_strINGS

strGetUNC

ByVal DriveLetter As String

STRING

UT_strINGS

strGetWhiteSpace

strFileName As String, strSection As String

STRING

UT_strINGS

strHardLine

UT_strINGS

strHexToChar

ByVal strText As String

STRING

UT_strINGS

strIdentifier

strBodyLine As String

STRING

UT_strINGS

strIncrementString

ByVal strIn As String, Optional intInc As Integer = 1

STRING

UT_strINGS

strIncrementStringPortion

str1 As String, Optional iNcrement As Integer = 1

STRING

UT_strINGS

strJulian

dtDate As Date

STRING

UT_strINGS

strLongest_Named_Files

strDataPath As String, strDataPattern As String, blnSearchSubFolders As Boolean

STRING

UT_strINGS

strMakePath

ByVal strPath As String

STRING

UT_strINGS

strMapAlphaToPhone

ByVal strText

STRING

UT_strINGS

strNext

strNow As String, strSet As String

UT_strINGS

strNot

strIn As String, strRef As String

STRING

UT_strINGS

strNotWhiteSpace

strFileName As String, strSection As String, strIn As String, strApplication As String

STRING

UT_strINGS

strNow

Optional strFormat As String = "yyyy/mm/dd hh:nn:ss"

STRING

UT_strINGS

strOnly

strIn As String, strRef As String

STRING

strOnly

UT_strINGS

strPAD

strText As String, strPadChar As String, intLen As Integer

STRING

UT_strINGS

strPattern

ByVal strIn As String, strCH As String

STRING

UT_strINGS

strPutString

strSource As String, strSubString As String, strDelimiter As String

UT_strINGS

strRandString

strText As String

STRING

UT_strINGS

strRemoveDuplicates

ByVal strIn As String, strCharacter As String

STRING

UT_strINGS

strReplaceAll

ByVal strSource As String, strFind As String, strReplace As String

STRING

UT_strINGS

strReplaceOnce

strIn As String, strFind As String, strReplace As String

STRING

UT_strINGS

strRotate

str As String, intR As Integer

UT_strINGS

strScrambleRange

rng As Range

STRING

UT_strINGS

strScreenResolution

STRING

UT_strINGS

strSoftLine

STRING

UT_strINGS

strSortString

strSource As String, Optional blnSequence As Boolean = True

STRING

UT_strINGS

strSortTextList

strText As String

UT_strINGS

strSpaceOnly

strIn As String, strRef As String

STRING

UT_strINGS

strSplitAt

strSource As String, strDelimiter As String

STRING

strSplitAt

UT_strINGS

strSplitFirstAt

strText As String, strDelimiter As String

STRING

UT_strINGS

strSplitFirstAtSpace

strText As String

STRING

UT_strINGS

strSplitLastAt

strText As String, strDelimiter As String

STRING

UT_strINGS

strSplitLastAtSpace

strText As String

STRING

UT_strINGS

strSplitNextItem

ByVal strBodyLine As String

STRING

UT_strINGS

strSplitStringAt

strIn As String, strDelim As String, blnDirection As Boolean

STRING

UT_strINGS

strSplitStringAtCapitals

ByVal strText As String

STRING

UT_strINGS

strSqueezeConsecutive

strIn As String, iCount As Integer

STRING

UT_strINGS

strStatusBar

strValue As String

STRING

UT_strINGS

strStringFromArray

strAr() As String

STRING

UT_strINGS

strStripEnds

ByVal strIn As String, strChar As String

STRING

UT_strINGS

strStripLineOfComments

ByVal strLine As String

STRING

UT_strINGS

strStripRight

ByVal strIn As String, ByVal strDel As String

STRING

UT_strINGS

strTab

STRING

UT_strINGS

strTimeConst

STRING

UT_strINGS

strTrim

strFileName As String, strSection As String, ByVal MyStr As String, strApplication As String, Optional strWhiteSpace

STRING

UT_strINGS

strTruncate

strText As String, intTruncate As Integer

UT_strINGS

strTypeOfDocument

strFile As String

STRING

UT_strINGS

strUCase

str As String, blnCS As Boolean

STRING

UT_strINGS

strUnPackIK

ByVal str1 As String, strDelimiter As String

STRING

UT_strINGS

strUnPackIKLW

ByVal strIn As String, strDelimiter As String, i1 As Integer, i2 As Integer, i3 As Integer

STRING

UT_strINGS

strWhoAmI

doc As Document

STRING

UT_strINGS

strWhoAmIProjectDateTime

doc As Document

STRING

UT_strINGS

strWhoAmIProjectFullName

doc As Document

STRING

UT_strINGS

strWhoAmIProjectName

doc As Document

STRING

UT_strINGS

strWhoAmIProjectVersion

doc As Document

STRING

UT_strINGS

strYesterDate

STRING

UT_Synonyms

strAntonymList

strWord As String, Optional intPosition

STRING

UT_Synonyms

strLookUpWordUsed

strWord As String

STRING

UT_Synonyms

strMeaningList

strWord As String, Optional intPosition

STRING

UT_Synonyms

strPartOfSpeechList

strWord As String, Optional intPosition

STRING

UT_Synonyms

strRelatedWordList

strWord As String, Optional intPosition

STRING

UT_Synonyms

strSynonymList

strWord As String, Optional intPosition

STRING

UT_TextInsertion

TypeDateAndInitials

WAR

Delete_Key_Tree

lngRoot As Long, strPath As String, strFolder As String

WAR

Open_Create_Key

lngRoot As Long, strPath As String, strFolder As String

WAR

OpenControl_Panel

WAR

SetValueEx

ByVal hKey As Long, sValueName As String, lType As Long, vValue As Variant

LONG

WD_BkMARKS

AddBookMark

rng As Range, strBkMk As String

WD_BkMARKS

BkMkPasteBookMark

strMyName As String

WD_BkMARKS

BkMkRanges

lngAr() As String, lngToDo() As String

WD_BkMARKS

BkmkSnagger

tbl As Table

WD_BkMARKS

blnBookmarkExists

strDocumentFullName As String, strBkMark As String

BOOLEAN

WD_BkMARKS

blnBookMarkText

strBookMark As String, strText As String

BOOLEAN

WD_BkMARKS

blnDeleteBookmarkedText

doc As Document, strBookMark As String

WD_BkMARKS

DumpBookmarkArray

strCurrentDoc As String, strDoc As String, strAr() As String

WD_BkMARKS

lngBuildBookmarkArray

strDoc As String, strAr() As String

LONG

WD_BkMARKS

lngRemoveBookmarks

strBkMk As String

LONG

WD_BkMARKS

strAddBookmark

rng As Range, intLevel As Integer, IntLengthText As Integer, Optional strHidden

STRING

WD_BkMARKS

strAllBookmarks

strDelim

STRING

WD_BkMARKS

strBookMarkDocumentor

STRING

WD_BkMARKS

strDumpBookmarkArray

strCurrentDoc As String, strAr As Variant

STRING

WD_BkMARKS

strGetBookMarkFromFile

strCourseDocument As String, strBkMk As String

STRING

WD_BkMARKS

strReplaceBookmark

doc As Document, strBookMark As String, strText As String

STRING

WD_BkMARKS

strValueBookmark

doc As Document, strBkMk As String

STRING

WD_BkMARKS

varBuildBookmarkArray

strDoc As String

VARIANT

WD_Booleans

blnAtEndOfDocument

BOOLEAN

blnAtEndOfDocument

WD_Booleans

blnAtStartOfDocument

BOOLEAN

blnAtStartOfDocument

WD_Booleans

blnCellsMerge

BOOLEAN

WD_Booleans

blnCheckSignature

strDoc As String, strSignature

BOOLEAN

WD_Booleans

blnClearAllGraphics

doc As Document, strReplace As String

BOOLEAN

WD_Booleans

blnCloseHeaderFooter

BOOLEAN

WD_Booleans

blnColumnBreak

strText As String

BOOLEAN

WD_Booleans

blnCopyProc

strFromTemplate As String, strFromModule As String, strFromProc As String, strToTemplate As String, strToModule As String, strToProc As String

BOOLEAN

WD_Booleans

blnDisconnectHeaderFooter

lngHeaderType As Long, blnDisconnect As Boolean

BOOLEAN

WD_Booleans

blnFieldExists

strFieldCode As String

BOOLEAN

WD_Booleans

blnFindFirstOccurrence

strFind As String

BOOLEAN

WD_Booleans

blnFindPreviousOccurrence

strFind As String

BOOLEAN

WD_Booleans

blnFindSelection

strText As String, blnCaseSensitive

BOOLEAN

WD_Booleans

blnFULLDocIsOpen

strFullName As String

WD_Booleans

blnGrammar

strText As String

WD_Booleans

blnHiddenText

boolSet As Boolean

BOOLEAN

WD_Booleans

blnIndexTableNames

doc As Document, strNameSearch As String

BOOLEAN

WD_Booleans

blnIsWordLoaded

BOOLEAN

WD_Booleans

blnMatchWords

str1 As String, str2 As String, strDelim As String

WD_Booleans

blnOpenFile

strFile As String, Optional strSignature

BOOLEAN

WD_Booleans

blnOpenHeaderFooter

lngtype As Long

BOOLEAN

WD_Booleans

blnSkip

m As Long, n As Long, blnRand As Boolean

WD_Booleans

blnSpelling

strText As String

WD_Booleans

blnSplitFromNextPage

lngPageNumber As Long, lngSectionNumber As Long, lngHeaderFooterType As Long

BOOLEAN

WD_Booleans

blnSplitFromPreviousPage

lngPageNumber As Long, lngSectionNumber As Long, lngHeaderFooterType As Long

BOOLEAN

WD_Booleans

blnStringInColumn

strArray() As String, lngColumn As Long, strCaption As String

BOOLEAN

WD_Booleans

blnStyleExists

strStylename As String

BOOLEAN

WD_Booleans

blnStyleInDocument

strStylename As String, strDoc As String

BOOLEAN

WD_Booleans

blnStyleIsValid

strStylename As String

BOOLEAN

WD_Booleans

blnTableRebuild

Optional intSeparatorType As Integer = wdSeparateByTabs

WD_Booleans

blnValidatePassword

strPrefix As String

BOOLEAN

WD_Booleans

blnWP51Doc

strFile As String

BOOLEAN

WD_Channels

blnChannelClose

doc As Document, ByVal strName As String, lngtype As Long

BOOLEAN

WD_Channels

blnChannelGet

STRING

WD_Channels

blnChannelGetFrom

doc As Document, ByVal strName As String, lngtype As Long

VARIANT

WD_Channels

blnChannelPut

varValue

WD_Channels

lngAddCustomDocumentProperties

strDoc As String, strIdentifier As String

LONG

WD_Docs

blnDocHasbeenSaved

doc As Document

WD_Docs

blnDocIsOpen

ByVal strDocName As String

BOOLEAN

WD_Docs

blnDocumentIsChanged

strFileName As String, strSection As String, doc As Document

BOOLEAN

WD_Docs

DocClose

strDoc As String, Optional blnSaveChanges As Boolean = False

WD_Docs

docOpenFile

strFile As String

DOCUMENT

WD_Docs

docSaveAsDoc

doc As Document

DOCUMENT

WD_Docs

docTryOpen

strFileName As String

DOCUMENT

WD_Docs

Document_Close

WD_Docs

DocUnDirty

doc As Document

WD_Docs

KeepWithNextParagraphs

rng As Range

WD_Docs

strSaveAsType

strFileName As String, strSection As String, strDoc As String, ByVal strType As String, strINFileName As String, strTargetPath As String, blnOverwrite As Boolean, lngBackColor As Long

STRING

WD_DocumentCharacteristics

ApplyStyle

rng As Range, str1 As String

WD_DocumentCharacteristics

blnAdjustParagraphSpacing

rng As Range, lngAdjust As Long

BOOLEAN

WD_DocumentCharacteristics

blnGlueTest

strAll As String, strChar1 As String, strChar2 As String

BOOLEAN

WD_DocumentCharacteristics

blnProtectedDocument

doc As Document

BOOLEAN

WD_DocumentCharacteristics

boolCheckSignature

strDoc As String, strSignature

BOOLEAN

WD_DocumentCharacteristics

CountParagraphsToArray

strDoc As String, strAr() As String

WD_DocumentCharacteristics

DumpReversedArrayToParagraphs

doc As Document, strAr() As String

WD_DocumentCharacteristics

intSqueezeDownPages

doc As Document, blnSame As Boolean

INTEGER

WD_DocumentCharacteristics

lngTopOfPage

rng As Range

WD_DocumentCharacteristics

NoProof

wrd As Range

WD_DocumentCharacteristics

strGetStamp

ByVal strChar As String, intCount As Integer

WD_DocumentCharacteristics

strPutStamp

ByVal strChar As String, ByVal strStamp As String

STRING

WD_DocumentCharacteristics

strSectionNumber

ByVal rng As Range

STRING

WD_DocumentCharacteristics

TitleDocument

doc As Document

WD_DocumentCharacteristics

WholeStoryTitleCase

sel As Selection

WD_DocumentVariables

DeleteAllCustomProperties

doc As Document

WD_DocumentVariables

LoadArrayFromDocVariables

doc As Document, strArray() As String, ByVal strPrefix As String, strDelimiter As String

WD_DocumentVariables

LoadArrayToDocVariables

doc As Document, strArray() As String, ByVal strPrefix As String, strDelimiter As String

WD_DocumentVariables

LoadVectorFromDocVariables

doc As Document, strVector() As String, ByVal strPrefix As String

WD_DocumentVariables

LoadVectorToDocVariables

doc As Document, strVector() As String, ByVal strPrefix As String

WD_DocVar

blnChannelClose

doc As Document, ByVal strName As String, lngtype As Long

BOOLEAN

WD_DocVar

blnChannelExists

doc As Document, ByVal strName As String

BOOLEAN

WD_DocVar

blnChannelOpen

doc As Document, ByVal strName As String

BOOLEAN

WD_DocVar

blnChannelPutTo

doc As Document, ByVal strName As String, lngtype As Long, VarVal

BOOLEAN

WD_DocVar

lngAddDocumentVariables

doc As Document, strIdentifier As String

LONG

WD_DocVar

lngIndexDocumentVariables

doc As Document, strIdentifier As String

LONG

WD_DocVar

varChannelGetFrom

doc As Document, ByVal strName As String

VARIANT

WD_Extensions

blnAddReference

strRef As String

WD_Extensions

blnClearReference

strRef As String

WD_Extensions

blnDeleteModule

doc As Document, ByVal strModule As String

BOOLEAN

WD_Extensions

blnModuleExists

doc As Document, ByVal strModule As String

BOOLEAN

WD_Extensions

blnModuleExistsInDocument

strModuleName As String, doc As Document

BOOLEAN

WD_Extensions

blnProcedureExists

strProc As String, Optional strTemplate As String = "Normal.dot"

BOOLEAN

WD_Extensions

blnProcedureExistsInModule

strProcedureName As String, strModuleName As String, doc As Document

BOOLEAN

WD_Extensions

blnReference

strRef As String

WD_Extensions

blnSearchModuleFor

strModule As String, strAr() As String, lngId As Long

BOOLEAN

WD_Extensions

blnSearchProcedureFor

strAr() As String, lngId As Long

BOOLEAN

WD_Extensions

blnSearchTemplateFor

strAr() As String, lngId As Long

BOOLEAN

WD_Extensions

blnTestLocked

doc As Document

WD_Extensions

blnTestLockedDocument

doc As Document

BOOLEAN

WD_Extensions

blnTestLockedTemplate

doc As Template

BOOLEAN

WD_Extensions

boolCopyProc

strFromTemplate As String, strFromModule As String, strFromProc As String, strToTemplate As String, strToModule As String, strToProc As String

BOOLEAN

WD_Extensions

boolProcedureExists

strProc As String, Optional strTemp

BOOLEAN

WD_Extensions

BuildCounts

doc As Document, strAr() As String

WD_Extensions

intCopyModules

docSource As Document, docTarget As Document

INTEGER

WD_Extensions

intDropAllAddins

INTEGER

WD_Extensions

intLoadProcsFromModule

objmod As Object, strAr() As String

INTEGER

WD_Extensions

intLoadProcsToModule

objmod As Object, strAr() As String

INTEGER

WD_Extensions

ListMacros

tmp As Template, strAr() As String

WD_Extensions

lngAddModule

strDoc As String, strModule As String

STRING

WD_Extensions

lngIsGet

cm As CodeModule, strName As String

LONG

WD_Extensions

lngIsLet

cm As CodeModule, strName As String

LONG

WD_Extensions

lngIsSet

cm As CodeModule, strName As String

LONG

WD_Extensions

lngTypeProc

cm As CodeModule, strName As String

LONG

WD_Extensions

LoadArrayToModule

doc As Document, strAr() As String, strUDoc As String

WD_Extensions

LoadArrayToModule2

strAr() As String, strUDoc As String

WD_Extensions

LoadModuleToArray

doc As Document, strAr() As String, strUDoc As String

WD_Extensions

LoadProcedures

objModule As VBComponent, strAr() As String, strType As String

WD_Extensions

strLoadDataFromModule

doc As Document, strModule As String

STRING

WD_Extensions

strLoadModuleFromData

doc As Document, strModule As String, strAr() As String

WD_Extensions

strPercentSystem

STRING

WD_Extensions

VBEOpen

WD_Extensions

VBEOpenUp

WD_Fields

AnalyseField

fld As Field, strCode As String, strType As String, strDrive As String, strPath As String, strName As String, strExtent As String

WD_Fields

AnalyseFieldCodeText

ByVal strFieldCodeText As String, strCode As String, strType As String, strDrive As String, strPath As String, strName As String, strExtent As String

WD_Fields

fldBrowseHyperlink

rng As Range, strPattern As String

FIELD

WD_Fields

LoadAllHyperlinksInRange

rng As Range

WD_Fields

PrintAllHyperlinksInRange

rng As Range

WD_Fields

SaveAllHyperlinksInRange

rng As Range, ByVal strPath As String

WD_Fields

strFieldNames

doc As Document, intFieldType As Integer

STRING

WD_Fields

UpdateAllFields

doc As Document

WD_Frames

DeleteFrames

rng As Range

WD_Frames

lngCountFrames

rng As Range

LONG

WD_Frames

SelectBackwardFrame

ByVal rng As Range

WD_Frames

SelectFirstFrame

rng As Range

WD_Frames

SelectForwardFrame

ByVal rng As Range

WD_Frames

SelectLastFrame

rng As Range

WD_ListBoxes

CopyListBoxToClipboard

lb As ListBox

WD_ListBoxes

lngIndexToListBox

lb As ListBox, strText As String, Optional blnCaseSensitive As Boolean = False

LONG

WD_ListBoxes

lngLoadArrayToListBox

strAr() As String, lb As ListBox

WD_ListBoxes

lngLoadListBoxToArray

lb As ListBox, strAr() As String

WD_ListBoxes

lngSortAndFilter

lb As ListBox, Optional strKey As String

WD_ListBoxes

LoadArrayToListBox

strAr() As String, lb As ListBox

WD_ListBoxes

LoadList

frmMe As UserForm, lb As ListBox, ByVal strPath As String, ByVal strExtent As String, boolRecurse As Boolean

WD_ListBoxes

LoadListPath

lb As ListBox, ByVal strPath As String, lngtype As Long

WD_ListBoxes

MoveMe

lbSource As ListBox, lbTarget As ListBox, boolForce As Boolean

WD_ListBoxes

SetLB

lb As ListBox, strIn As String

WD_ListBoxes

SortListBox

lb As ListBox, intCol As Integer, Optional blnNoDuplicates

WD_ListBoxes

SqueezeLB

lbLeft As ListBox, lbRight As ListBox, sb As SpinButton, tbHits As TextBox, lngDirection As Long

WD_ListBoxes

strLb

lb As ListBox

STRING

WD_Longs

lngAckerman

ByVal intx As Integer, ByVal inty As Integer

LONG

WD_Longs

lngBackUpToNonHiddenText

WD_Longs

lngClearDocument

LONG

WD_Longs

lngClearModuleText

strDoc As String, strModule As String

LONG

WD_Longs

lngClearShape

rng As Range, Optional lngShapeType

LONG

WD_Longs

lngCountChars

rng As Range, strChar As String

LONG

WD_Longs

lngCountCharsInString

strIn As String, strChar As String

LONG

WD_Longs

lngCountLines

rng As Range

LONG

WD_Longs

lngCountLinesInTOC

strDoc As String

LONG

WD_Longs

lngCountUniqueParagraphs

rng As Range

LONG

WD_Longs

lngCountUniqueWords

rng As Range

LONG

WD_Longs

lngCountWords

rng As Range

LONG

WD_Longs

lngDeleteDuplicateRows

rngTbl As Range, intCount As Integer

LONG

WD_Longs

lngDiscardInValidStyles

strAr() As String, doc As Document

LONG

WD_Longs

lngDropDuplicates

rng As Range

LONG

WD_Longs

lngDropDuplicatesFromSortedArray

strAr() As String, blnCaseSensitive As Boolean

LONG

WD_Longs

lngEndString

strIn As String, ByVal lngStart As Long, strChars As String, lngInc As Long

WD_Longs

lngFactorial

lngNum As Long

LONG

WD_Longs

lngFixHyperlinks

rng As Range

LONG

WD_Longs

lngGetCurrentPageNumber

lngOffset As Long

WD_Longs

lngGetCurrentSectionNumber

WD_Longs

lngGetTableIndex

LONG

WD_Longs

lngGoToPage

intPosition As Integer, lngPageNumber As Long

LONG

WD_Longs

lngHeadingToIndex

strStyle As String

LONG

WD_Longs

lngIndexCustomDocumentProperties

strDoc As String, strIdentifier As String

LONG

WD_Longs

lngInsertBreak

lngBreakType As Long

LONG

WD_Longs

lngInStr

lngStart As Long, strString As String, strDelims As String

LONG

WD_Longs

lngMax

lng1 As Long, lng2 As Long

LONG

WD_Longs

lngMod

MV As Long, MB As Long

LONG

WD_Longs

lngModuleExists

strDoc As String, strModule As String

LONG

WD_Longs

lngOrInstr

Start As Long, MainString As String, Charset As String

LONG

WD_Longs

lngParagraphStylesInDoc

strAr() As String, doc As Document

LONG

WD_Longs

lngRemoveFields

doc As Document, lngFieldType As Long

LONG

WD_Longs

lngRemoveShapes

doc As Document

LONG

WD_Longs

lngReplaceAll

rng As Range, strFind As String, strReplace As String

LONG

WD_Longs

lngReplaceOnePass

rng As Range, strFind As String, strReplace As String

LONG

WD_Longs

lngRuleOfSeven

rng As Range, intLimit As Integer

LONG

WD_Longs

lngSelectNextPage

LONG

WD_Longs

lngSelectNextWord

LONG

WD_Longs

lngSortByLength

rng As Range

LONG

WD_Longs

lngStylesInDoc

strAr() As String, doc As Document

LONG

WD_Longs

lngStylesInUseInDoc

strAr() As String, doc As Document

LONG

WD_Longs

lngUniqueStrings

ByVal strIn As String, strDels As String, strAr() As String, Optional blnCase As Boolean = False

LONG

WD_Longs

lngUpdateDocumentFields

WD_Longs

lngUpdateTOC

strDoc As String

LONG

WD_Longs

lngWordsIn

strAr1() As String, strAr2() As String, Optional blnCase As Boolean = True, Optional lngCutOff

LONG

WD_Miscellaneous

AddReference

strReference As String

WD_Miscellaneous

AllBut

intItemList() As Integer, intI As Integer, intJtemlist() As Integer

WD_Miscellaneous

AllButValues

intItemList() As Integer, intI As Integer, intv As Integer

WD_Miscellaneous

AppendToArray

strAr() As String, str1 As String, Optional str2

WD_Miscellaneous

AssignKey

strMacro As String, lngKey As Long

WD_Miscellaneous

Beeper

intDuration As Integer

WD_Miscellaneous

BestFit2

intItemList() As Integer, intBucketsize As Integer, intStackSize As Integer

WD_Miscellaneous

blnSaveBackup

docDocument As Word.Document

BOOLEAN

WD_Miscellaneous

blnStringInColumn

strArray() As String, lngColumn As Long, strCaption As String

BOOLEAN

WD_Miscellaneous

Blue

rng As Range

WD_Miscellaneous

BuildIndexTables

WD_Miscellaneous

CleanHeadNames

Optional strFollow As String = "", Optional intTail As Integer = 0

WD_Miscellaneous

ClearString

strIn As String

WD_Miscellaneous

dblMin

dbl1 As Double, dbl2 As Double

DOUBLE

WD_Miscellaneous

DelayMe

sngSeconds As Single

WD_Miscellaneous

doMakeTextBox

WD_Miscellaneous

DropDuplicatesFromFile

strFileName As String

WD_Miscellaneous

dtLastDayOfPreviousMonth

dtDate As Date

DATE

WD_Miscellaneous

DumpArray

strAr() As String

WD_Miscellaneous

DumpArrayToParagraphs

rng As Range, strArp() As String, Optional strTrail

WD_Miscellaneous

DuplicateSelectionFontProperties

rng As Range

WD_Miscellaneous

EnsureDocument

WD_Miscellaneous

ERL

strFileName As String, strSection As String, ByVal strCode As String, ByVal intStatusCode As Integer, ByVal strMsg As String

WD_Miscellaneous

ExtractEmailAddresses

strData As String, strIdentifier As String, strDelimiters As String, strCharacterSet As String, strOutFile As String

WD_Miscellaneous

FindBoldUpward

WD_Miscellaneous

FindExecutable

s As String

STRING

WD_Miscellaneous

FindString

intLoc() As Integer, str1 As String, str2 As String

WD_Miscellaneous

FindSubStrings

strAr() As String, ByVal strIn As String

WD_Miscellaneous

FlushEditUndo

WD_Miscellaneous

funRandomise

iNum As Integer

INTEGER

WD_Miscellaneous

GenerateTOC

strFileName As String, strSection As String, strDoc As String, Optional blnTop As Boolean = True

WD_Miscellaneous

GetFontCount

WD_Miscellaneous

GetTodo

lngAr() As String, ByVal lngStoryStart As Long, lngStoryEnd As Long, lngToDo() As String

WD_Miscellaneous

GoBack

strBar As String, strButton As String, intCount As Integer

WD_Miscellaneous

HLink

strPath As String, ByVal strNameString As String, strDelim As String

WD_Miscellaneous

IncrementBuildSequence

WD_Miscellaneous

inStrLast

strString As String, strFind As String

LONG

WD_Miscellaneous

intCharacterCode

strCH As String

INTEGER

WD_Miscellaneous

intCountWords

strText As String, strDelimiter As String

INTEGER

WD_Miscellaneous

intDocumentSequence

strIdentifier As String, intIncrement As Integer

INTEGER

WD_Miscellaneous

intGetBuildSequence

INTEGER

WD_Miscellaneous

intMin

int1 As Integer, int2 As Integer

INTEGER

WD_Miscellaneous

intRank

strAr() As String

INTEGER

WD_Miscellaneous

intRemoveText

strFirst As String, strLast As String, intDelta As Integer, intFuzz As Integer

WD_Miscellaneous

intSaveAsType

strDoc As String, ByVal strType As String, strFileName As String

INTEGER

WD_Miscellaneous

IsOpen

strDocName As String

BOOLEAN

WD_Miscellaneous

KevinTimer

WD_Miscellaneous

KevinTimer2

WD_Miscellaneous

LastRowWithParagraph

rngTbl As Range

WD_Miscellaneous

lngAddToListBox

lb As ListBox, strCaption As String

LONG

WD_Miscellaneous

lngEndString

strIn As String, ByVal lngStart As Long, strChars As String, lngInc As Long

WD_Miscellaneous

LoadSubSet

lngSubSet() As Long, lngItems() As Long, intI As Integer

WD_Miscellaneous

LoadTwoColumnTable

strIK() As String

WD_Miscellaneous

NoMove

cb As CommandBar

WD_Miscellaneous

NukeAddIn

strAddIn As String

WD_Miscellaneous

NukeReference

strReference As String

WD_Miscellaneous

OldboolMaskCompare

strMask As String, strCandidate As String

BOOLEAN

WD_Miscellaneous

OpenFooter

WD_Miscellaneous

OpenHeader

WD_Miscellaneous

QualifyProcedure

strProcBody As String, strPublic As String, strFunction As String, strArguments As String, strType As String

WD_Miscellaneous

ReduceSet

lngItems() As Long, lngResult() As Long

WD_Miscellaneous

RemoveNamedFields

doc As Document, intFieldType As Integer, strIdentifer As String

STRING

WD_Miscellaneous

RestartNumbering

intStart As Integer

WD_Miscellaneous

Sampler

WD_Miscellaneous

sngDropCapital

intMultiplier As Integer

SINGLE

WD_Miscellaneous

strCharsFromDigit

strDigit As String

STRING

WD_Miscellaneous

strGrabAddress

doc As Document

STRING

WD_Miscellaneous

StringInString

szSearchIn As String, szSearchFor As String

VARIANT

WD_Miscellaneous

strInsert

strLink As String, intLinkType As Integer

STRING

WD_Miscellaneous

strStripCommentsFromLine

ByVal strLine As String

STRING

WD_Miscellaneous

strTruncate

strText As String, intTruncate As Integer

WD_Miscellaneous

strWith

strIn As String, strOut As String

WD_Miscellaneous

TimeDelay

dt As Date

WD_Miscellaneous

TMsgBox

str As String, booldebug As Boolean

WD_Miscellaneous

Trace

strMsg As String

WD_Miscellaneous

TypeOneCharPerParagraph

str1 As String

WD_Miscellaneous

UIMsg

str1, str2

WD_Miscellaneous

UpdateIndexTables

doc As Document

STRING

WD_Miscellaneous

varListPrinters

VARIANT

WD_Miscellaneous

WriteLargePrivateProfileString

ByVal lpApplicationName As String, ByVal lpKeyName As String, ByVal lpString As String, ByVal lpFileName As String

STRING

WD_Miscellaneous

YesMove

cb As CommandBar

WD_Parags

blnKeepParagraphs

rng As Range

BOOLEAN

WD_Parags

lngParagraphNumber

INTEGER

WD_Parags

lngParagraphRangeNumber

rng As Range

INTEGER

WD_Ranges

blnFindText

rng As Range, strFind As String

BOOLEAN

WD_Ranges

blnReplaceAll

rng As Range, strFind As String, strReplace As String

BOOLEAN

WD_Ranges

CleanEmptyParagraphsRng

rng As Range

WD_Ranges

KeepWithBefore

rng As Range

WD_Ranges

lngChompRange

ByRef rng As Range, strChars As String

LONG

WD_Ranges

ReplaceString

rng As Range, strTab As String

WD_Ranges

rngDocTags

strDoc As String, strTag1 As String, strTag2 As String, blnIncExc

RANGE

WD_Ranges

rngFindBoldUpward

RANGE

WD_Ranges

rngGetNext1stSentenceOutsideIncludeFields

prg As Paragraph, intType As Integer

RANGE

WD_Ranges

rngGetNextField

strType As String, Optional strName As String = ""

RANGE

WD_Ranges

rngGetOutsideField

rngIn As Range, intType1 As Integer, Optional intType2

RANGE

WD_Ranges

rngLines

ByVal rng As Range, intN As Integer

RANGE

WD_Ranges

rngObtainNumberedParagraphs

rngIn As Range

RANGE

WD_Ranges

rngTableNextTable

RANGE

WD_Ranges

rngTableSelectRow

RANGE

WD_Ranges

rngTableStart

RANGE

WD_Strings

blnCheckSignature

strDoc As String, strSignature

BOOLEAN

WD_Strings

blnColumnBreak

strText As String

BOOLEAN

WD_Strings

blnCopyProc

strFromTemplate As String, strFromModule As String, strFromProc As String, strToTemplate As String, strToModule As String, strToProc As String

BOOLEAN

WD_Strings

blnDisconnectHeaderFooter

lngHeaderType As Long, blnDisconnect As Boolean

BOOLEAN

WD_Strings

blnIndexTableNames

doc As Document, strNameSearch As String

BOOLEAN

WD_Strings

blnStyleIsValid

strStylename As String

BOOLEAN

WD_Strings

blnTableRebuild

Optional intSeparatorType As Integer = wdSeparateByTabs

WD_Strings

LoadParagraphsToArray

rng As Range, strArp() As String, Optional blnDropDuplicates

WD_Strings

ReplaceAll

strIn As String, strOut As String

WD_Strings

SortArray

myArray As Variant, intSeq As Integer, intType As Integer, intKey As Integer

WD_Strings

strAppInfo

WD_Strings

strComputerName

STRING

WD_Strings

strDocumentStamp

doc As Document

STRING

WD_Strings

strDropMacros

doc As Document

STRING

WD_Strings

strFindBoldUpward

WD_Strings

strGetFile

STRING

WD_Strings

strGetHeaderFooterText

lngHeaderType As Long, Optional strNewtext

STRING

WD_Strings

strGetNextWord

strSource As String, lngStart As Long, strValid As String, strNesters As String

STRING

WD_Strings

strGetSentencesDoc

strDoc As String, rngCandidate As Range, ByVal intSentences As Integer

WD_Strings

strGetUserInfo

STRING

WD_Strings

strGetWordsDoc

strDoc As String, rngCandidate As Range, ByVal intWords As Integer

WD_Strings

strGrabEntireParagraph

STRING

WD_Strings

strIndexTableNames

doc As Document

STRING

WD_Strings

strModifyHeaderFooterThisPage

strText As String, lngHeaderType As Long

STRING

WD_Strings

strRecentFiles

Optional strDelim As String = ","

WD_Strings

strSaveAsRTF

doc As Document

STRING

WD_Strings

strSaveAsUnique

strDocName As String, ByVal strSet As String, intLen As Integer, strPath As String, strName As String, strExtent As String

STRING

WD_Strings

strSnagText

STRING

WD_Strings

strSysInfo

WD_Strings

strTemplatePath

Optional strDelim

STRING

WD_Strings

strTextOfRow

rngRows As Range, intColumns As Integer

STRING

WD_Strings

strUserName

STRING

WD_Strings

strValueOfKey

strSectionData As String, lngKeyStart As Long, lngKeyEnd As Long

STRING

WD_Strings

TextReplace

wrd As Range, str1 As String

WD_Strings

WriteCodeArray

strFileName As String, strAr() As String

WD_Styles

AddStyle

strStylename

WD_Styles

AddStylesToArray

doc As Document, strAr() As String

WD_Styles

AddStyleToDocument

strStylename As String, doc As Document

WD_Styles

AddStyleToTable

varStyleRanges(), strStylename

WD_Styles

ApplyStyleall

strStyle As String, strFindText As String

WD_Styles

ArrayStylesFromDocument

doc As Document, strAr() As String

WD_Styles

ArrayStylesFromTemplate

doc As Template, strAr() As String

WD_Styles

ArrayStylesInUseDocument

doc As Document, strAr() As String

WD_Styles

blnStyleInUse

doc As Document, ByVal strStylename As String

BOOLEAN

WD_Styles

doCStyleNew

strName

WD_Styles

doPStyleNew

strName

WD_Styles

InsertStyleNamesrng

rng As Range

WD_Styles

intMaxHeadingStyle

strDoc As String

INTEGER

WD_Styles

intMinHeadingStyle

strDoc As String

INTEGER

WD_Styles

lngStyleInDocument

doc As Document, strStyle As String

LONG

WD_Styles

MakeParaStyle

strName As String

WD_Styles

RemoveAllStyleAliases

doc As Document

WD_Styles

ReplaceStyle

rng As Range, strStyleFind As String, strStyleReplace As String

LONG

WD_Styles

SetStyle

strStyle As String, lngColour As Long, lngUnderline As Long

WD_Styles

sngAdjustStyleFontSize

rng As Range, sngAdjust As Single

SINGLE

WD_Styles

strAllStyles

doc As Document, strDelim As String

STRING

WD_Styles

strStylesInDOC

doc As Document, strDelim As String

STRING

WD_Styles

strStylesInTEMPLATE

strResult As String, tmp As Document, strDelim As String

STRING

WD_Styles

StrStylesInUse

doc As Document, strDelimiter As String

STRING

WD_Styles

StyleInDoc

sty

WD_Styles

StyleLockton

doc As Document

WD_TablesAndCells

BestFit

rngTbl As Range

WD_TablesAndCells

blnCellsMerge

BOOLEAN

WD_TablesAndCells

CellsBox

rngCells As Range

WD_TablesAndCells

CellsGrid

rngCells As Range

WD_TablesAndCells

CellsNone

rngCells As Range

WD_TablesAndCells

ConvertToTabs

rngTbl As Range, strDelim As String

WD_TablesAndCells

DeleteAllTables

rng As Range

WD_TablesAndCells

DeleteBlankRows

strFileName As String, strSection As String, rngTbl As Range, strApplication As String

WD_TablesAndCells

errMustBeInTable

WD_TablesAndCells

errMustBeOutTable

WD_TablesAndCells

FormatTable

rngTbl As Range

WD_TablesAndCells

GetTableSelectionDetails

WD_TablesAndCells

lngAdjustRowHeight

rng As Range, lngAdjust As Long

LONG

WD_TablesAndCells

NoSplit

rngTbl As Range

WD_TablesAndCells

rngFindNextNonEmptyCell

cl As Cell

RANGE

WD_TablesAndCells

strCellText

rng As Range

STRING

WD_TablesAndCells

TableRebuild

rngTbl As Range, Optional intSeparatorType As Integer = wdSeparateByTabs

WD_TablesAndCells

TableSort

rngTable As Range, intColumn As Integer, lngSortOrder

WD_TablesAndCells

tblTableReBuild

tbl As Table

TABLE

WD_TablesAndCells

Tokenise

strFileName As String, strSection As String, rngTbl As Range

WD_UserF

AddArrayCheckBoxes

TempForm, strCaption As String, lngTop As Long, lngLeft As Long, lngHeight As Long, lngWidth As Long, lngGap As Long, DataArray, CodeArray

COMMANDBUTTON

WD_UserF

AddArrayListBox

TempForm, strCaption As String, lngTop As Long, lngLeft As Long, lngHeight As Long, lngWidth As Long, lngGap As Long, DataArray, CodeArrayClick

COMMANDBUTTON

WD_UserF

AddArrayOptionsButtons

TempForm, strCaption As String, lngTop As Long, lngLeft As Long, lngHeight As Long, lngWidth As Long, lngGap As Long, DataArray

COMMANDBUTTON

WD_UserF

AddCodeLines

TempForm, strLine

WD_UserF

AddCommandButton

TempForm, strCaption As String, lngTop As Long, lngLeft As Long, lngHeight As Long, lngWidth As Long, lngGap As Long, strDataArray, strCodeArray, blnAutoSize As Boolean, blnWordWrap As Boolean

COMMANDBUTTON

WD_UserF

BuildCheckBoxForm

doc As Document, TempForm, OpArray, Default, Title, blnRun As Boolean, lngTop As Long, lngLeft As Long, lngHeight As Long, lngWidth As Long, lngGap As Long, strItemDelimiter As String

VARIANT

Word97Pass1

blnWP51Doc

strFile As String

BOOLEAN

Word97Pass1

ObtainFileNamesArray

strPath As String, strExtents As String, blnWPerfect As Boolean, strAr() As String

Word97Pass1

strGetStatus

strFullName As String, strExtents As String, blnWPerfect As Boolean

STRING

Contact Me