ThreeWave Downloads

This page lists the files available for download.
ShortFadeBar

Files whose names begin with mod are bas or cls module files. Those files whose names do not begin with mod are xls workbooks. The code modules are compressed in the zip file format. You should use an unzipping program such as PKZip, SecureZIP, or WinZip to decompress the code files.

Page TitlePage LinkDownload Link
Adding The COM Add-Ins Menu ItemAddingCOMAddInsMenuItem.aspxComAddInInstaller.zip
Alert Message Display ComponentAlert.aspxAlerterSample.ZIP
Alert Message Display ComponentAlert.aspxAlerterSetup.zip
Alert Message Display ComponentAlert.aspxAlertSetup.zip
Alerter Program For Office DevelopersAlert.htmAlert.dll
Alerter Program For Office DevelopersAlert.htmAlerterSample.ZIP
Application EventsAppEvent.htmAPPEVENT.ZIP
Array To Columnarr2col.htmARR2COL.ZIP
Array FormulasArrayFormulas.aspxArrayFormulas.zip
Automation Add InsAutomationAddIns.aspxComAddInInstaller.zip
Creating Automation Add-Ins In VB6AutomationAddins.htmExampleAutomationAddIn.zip
Color Banding With Conditional Formattingbanding.htmBanding.zip
A Better NETWORKDAYSBetterNetWorkDays.aspxmodBetterWorkday.zip
A Better Union For VBABetterUnion.aspxRegWorx.zip
Better WorkdayBetterWorkday.aspxBetterWorkday.zip
Better WorkdayBetterWorkday.aspxmodBetterWorkday.zip
Bits And BytesBitsAndBytes.aspxmodBitsAndBytes.zip
Browse For FolderBrowseFolder.aspxmodBrowseFolder.zip
CellView Add InCellView.aspxCellView.zip
Cell ViewCellView.htmCellView.ZIP
Character FunctionsCharacterFunctions.aspxRegWorx.zip
Special Characters In Excelchars.htmsymbol.ZIP
Class BuilderClassBuilder.aspxRegWorx.zip
Windows ClipboardClipboard.aspxmodClipboard.zip
Clone FolderCloneFolder.htmmodCloneFolder.zip
Clone FolderCloneFolder.htmmodCloneFolderEx.zip
Sorting A Collection Or DictionaryCollectionsAndDictionaries.htmCollectionsAndDictionaries.zip
Sorting A Collection Or DictionaryCollectionsAndDictionaries.htmmodArraySupport.zip
Sorting A Collection Or DictionaryCollectionsAndDictionaries.htmmodCollectionAndDictionaries.zip
Sorting A Collection Or DictionaryCollectionsAndDictionaries.htmmodQSortInPlace.zip
Sorting A Collection Or DictionaryCollectionsAndDictionaries.htmQSortObjectsInPlace.zip
Color Functions In ExcelColors.aspxmodColorFunctions.zip
Column To TableColumnToTable.aspxColumnsToTable.zip
COM Add-Ins In Excel 2007COMAddIn2007.aspxComAddInInstaller.zip
Creating A COM Add-In In VB6ComAddInInVB6.htmComAddInInstaller.zip
Creating A COM Add-In In VB6ComAddInInVB6.htmExampleCAIProject.zip
Installing COM AddInsCOMAddInsSecurity.aspxComAddInInstaller.zip
Complete Platform DevelopementCompletePlatformDevelopment.aspxRegWorx.zip
Content BandingContentBanding.aspxContentBanding.zip
CPearson.comContentTemplate.aspxRegWorx.zip
Creating An XLA Add InCreateAddIn.aspxTestAddIn.zip
Create GUIDCreateGUID.aspxRegWorx.zip
Creating A COM Add InCreatingCOMAddIn.aspxExampleCOMAddIn.zip
Creating A Function Library In .NETCreatingNETFunctionLib.aspxMathNET.zip
Data Blocks On WorksheetsDataBlocks.aspxRegWorx.zip
Excel Date FunctionsDateFunctions1.aspxDateFunctions1.zip
Worksheet Functions For Dates And TimesDateTimeWS.htmDateInterval.zip
Daylight Savings TimeDaylightSavings.htmmodDST.zip
Day Of Week FunctionsDayOfWeekFunctions.aspxDayOfWeekFunctions.zip
Day Of Week FunctionsDayOfWeekFunctions.aspxmodDayOfWeekFunctions.zip
Defined NamesDefinedNames.aspxRegWorx.zip
Deleting Duplicate Rows With Advanced FilterDeleteDupsWithFilter.aspxmodDeleteDupsFilter.zip
Deleting Duplicates With Advanced FilterDeleteDupsWithFilter.htmmodDeleteDupsFilter.zip
Language=DelimitedText.aspxRegWorx.zip
Detecting Scrolling In A Worksheet WindowDetectScroll.htmScrollEvents.zip
My Dev BoxDevBox.aspxRegWorx.zip
Directory Tree RedirectDirTree.aspxRegWorx.zip
Distinct Values FunctionDistinctValues.aspxDistinctValues.zip
Distributing Days Over Intervalsdistribdates.htmSplitDates.ZIP
DLL Name Of COM AddInDLLNameOfComAddin.htmDLLNameOfCOMAddin.zip
DLL Name Of COM AddInDLLNameOfComAddin.htmmodDLLOfComAddin.zip
Document PropertiesDocProp.aspxmodDocumentProperties.zip
Duplicates In Data In ExcelDuplicates.aspxDuplicates.zip
Easter CalculationEaster.aspxRegWorx.zip
Empty A FolderEmptyFolder.htmmodEmptyFolder.zip
Enum Name Value ListEnumNameList.aspxmodEnumValueNames.zip
Error Hanlding In VBAErrorHandling.aspxRegWorx.zip
EveryNth RowEveryNth.aspxEveryNth.zip
Excel FormulasexcelF.htmFIRSTL~1.ZIP
Excel FormulasexcelF.htmMINMAX.ZIP
Excel FormulasexcelF.htmRANK.ZIP
Excel FormulasexcelF.htmSUMEVERY.ZIP
Excel FormulasexcelF.htmXLNAMES.ZIP
Excel MacrosexcelM.htmHILITE.ZIP
Excel PagesExcelPages.aspxGetDistinct.zip
Excel PagesExcelPages.htmRowLiner.ZIP
Detecting When Excel Shuts DownExcelShutdown.htmmodHiddenNames.zip
Detecting When Excel Shuts DownExcelShutdown.htmTestExcelShutdown.zip
File Extensions In VBAFileExtensions.aspxmodWindowCaption.zip
Changing File Times With VBAFileTimes.htmGetSetFileDateTime.zip
Changing File Times With VBAFileTimes.htmmodGetSetFileTimes.zip
FindAll VBA FunctionFindAll.aspxmodFindAll.zip
FindAll XLA Add-InFindAllXLA.aspxFindAll.zip
FlexLookupFlexLookup.aspxFlexLookup.zip
FlexLookupFlexLookup.aspxRegWorx.zip
Directory Tree ListingsFolderTree.aspxDirTreeSetup.zip
Folder/File Tree ViewFolderTreeView.aspxCreatingATreeView.zip
GetSystemMessageTextFormatMessage.aspxmodGetSystemErrorMessageText.zip
Windows API Function Errors And FormatMessageFormatMessage.htmmodFormatMessage.zip
Extending VBA UserFormsFormControl.aspxUserFormControl.zip
Form PositionerFormPosition.htmformposition.ZIP
Fractional ArithmeticFractionalArithmetic.aspxFractional.zip
Fractional MonthsFractionalMonths.aspxRegWorx.zip
Full File Name In Window CaptionFullFileNameInWindowCaption.aspxRegWorx.zip
Excel Gamesgames.htmBingo.ZIP
Excel Gamesgames.htmdhgames.zip
Excel Gamesgames.htmMineSweeper.ZIP
Excel Gamesgames.htmXRay.ZIP
Returning Distinct Items In A RangeGetDistinct.aspxGetDistinct.zip
Returning Distinct Items In A RangeGetDistinct.aspxRegWorx.zip
Get FileNameGetFileName.aspxmodGetRecentFile.zip
Get FileNameGetFileName.aspxmodRecentFile2.zip
GetInfoGetInfo.htmGetInfo.ZIP
Hidden Name Spacehidden.htmmodHiddenNames.zip
Importing Big Text Files Into ExcelImportBigFiles.aspxmodImportBigFiles.zip
Importing Big Text Files Into ExcelImportBigFiles.aspxmodImportBigFilesFunction.zip
Inserting Procedure NameInsertProcedureNames.aspxmodInsertProcNames.zip
Testing If An Array Is SortedIsArraySorted.aspxmodIsArraySorted.zip
Test If A File Is OpenIsFileOpen.aspxmodIsFileOpen.zip
KeyboardShortcutsKeyboardShortcuts.htmXLKeys.ZIP
Testing Key StatesKeyTest.aspxmodKeyState.zip
Testing For SHIFT, CTRL, and ALT KeysKeyTest.htmmodKeyState.zip
Last Cell In RangeLastCell.aspxmodLastCell.zip
Latitude And LongitudeLatLong.aspxLatLong.zip
Latitude And Longitudelatlong.htmLATITU~1.ZIP
Latitude And Longitudelatlong.htmLatLongExample.zip
Linked List BoxesLinkedListBoxes.aspxLinkedListBoxes.zip
Linked List BoxesLinkedListBoxes.aspxRegWorx.zip
ListBox UtilitiesListBoxUtils.aspxListBoxUtils.zip
ListBox UtilitiesListBoxUtils.aspxmodListBoxUtils.zip
ListBox UtilitiesListBoxUtils.aspxRegWorx.zip
List Box UtilitiesListBoxUtils.htmListBoxUtils.zip
List Box UtilitiesListBoxUtils.htmmodListBoxUtils.zip
List FunctionsListFunctions.aspxLists2.zip
Local And GMT TimesLocalAndGMTTimes.htmGetSetFileDateTime.zip
Local And GMT TimesLocalAndGMTTimes.htmLocalTimeAndGMT.zip
Local And GMT TimesLocalAndGMTTimes.htmmodLocalTimeAndGMT.zip
Lookupslookups.htmlookup.ZIP
Create Multiple DirectoriesMakeDirMulti.aspxmodMakeMultiStepDirectory.zip
Create Multiple DirectoriesMakeDirMulti.aspxRegWorx.zip
Make Multiple DirectoriesMakeDirMulti.htmmodMakeMultiDir.zip
Matrix To VectorMatrixToVector.aspxMatrixToVector.zip
Merge Lists To Distinct ListMergeListsToDistinct.aspxmodMergeDistinct.zip
Merge Lists To Distinct ListMergeListsToDistinct.aspxRegWorx.zip
Multiple File Import And ExportMultiFileImportExport.htmVbeImportExport.zip
Multiple File Import And ExportMultiFileImportExport.htmVbeMultiDLL.zip
Named Rangesnamed.htmDYNARA~1.ZIP
Eliminating Blank Cells In A RangeNoBlanks.aspxNoBlanks.zip
Eliminating Blank Cells From Listsnoblanks.htmNoBlanks.zip
Numbering Lists In ExcelNumberingLists.aspxRegWorx.zip
Working With Times Example Pageovertime.htmovertime.zip
Passing And Returning Arrays With FunctionsPassingAndReturningArrays.htmmodArraySupport.zip
Playing A Sound In VBAPlaySound.aspxRegWorx.zip
Testing For Prime NumbersPrimeNumbers.aspxPrimes.zip
Print Multiple SheetsPrintMultipleSheets.aspxmodPrintMultipleSheets.zip
Progress IndictorProgress.htmProgressor.ZIP
Sorting Arrays With QSortQSort.htmmodQSortInPlace.zip
QSortObjectCompare Example ProcedureQSortObjectCompare.htmmodQSortObjectsInPlace.zip
Quick Folder Tree In ExcelQuickTree.aspxDirTreeSetup.zip
Quick Folder Tree In ExcelQuickTree.aspxmodQuickDirTree.zip
Quick Folder Tree In ExcelQuickTree.aspxRegWorx.zip
Random NumbersRandom.htmmodRandomNumbers.zip
Random NumbersRandom.htmRandomNumbers.zip
Random Numbers In ExcelRandomNumbers.aspxmodRandomNumbers.zip
Random Numbers In ExcelRandomNumbers.aspxRandomNumbers.zip
Using The Range Find Method In VBARangeFind.htmmodFindUltilities.zip
Using The Range Find Method In VBARangeFind.htmSearch.zip
Ranking Data In ListsRank.aspxRank2.zip
Ranking Data In Listsrank.htmRANK.ZIP
Recycle A File Or FolderRecycle.aspxmodRecycleVBA.zip
Recycle A File Or FolderRecycle.htmmodRecycle.zip
Registry FunctionsRegistry.htmmodFormatMessage.zip
Registry FunctionsRegistry.htmmodRegistry.zip
Registry FunctionsRegistry.htmRegistry.zip
RegistryWorxRegistryWorx.aspxRegWorx.zip
Preventing Problems With Worksheet RenamingRenameProblems.aspxRegWorx.zip
Returning Errors From VBAReturningErrors.aspxRegWorx.zip
RowLiner Add-InRowLiner.htmRowLiner.ZIP
Untitled PageSample.aspxRegWorx.zip
SaveCopyAndZip Add-InSaveCopyAndZip.htmSaveCopyAndZip.zip
SaveCopyAndZip Add-InSaveCopyAndZip.htmSaveCopyAndZipSETUP.zip
Testing Series ContentSeriesTest.aspxmodSeriesInfo.zip
SetFocus For VBA UserFormsSetFocus.aspxRegWorx.zip
SetProp And GetPropSetGetProp.htmGetSetProp.zip
SetProp And GetPropSetGetProp.htmmodGetSetProps.zip
Pearson Software ConsultingSetParent.aspxSetParent.zip
VBA Function For WorksheetsSheetNameFunctions.aspxmodSheetFunctions.zip
VBA Function For WorksheetsSheetNameFunctions.aspxRegWorx.zip
Shell And WaitShellAndWait.aspxmodShellAndWait.zip
Shell And Wait, Simple And EnhancedShellAndWait.htmmodShellAndWaitEnhanced.zip
Shell And Wait, Simple And EnhancedShellAndWait.htmmodShellAndWaitEnhancedVB6.zip
Shell And Wait, Simple And EnhancedShellAndWait.htmmodShellAndWaitSimple.zip
Shell And Wait, Simple And EnhancedShellAndWait.htmmodShellAndWaitSimpleVB6.zip
Shell And Wait, Simple And EnhancedShellAndWait.htmShellAndWait.zip
Shell And Wait, Simple And EnhancedShellAndWait.htmShellAndWaitEnhanced.zip
Shell And Wait, Simple And EnhancedShellAndWait.htmShellAndWaitSimple.zip
Shell And Wait, Simple And EnhancedShellAndWait.htmShellAndWaitVB6.zip
Shortcut Keys In ExcelShortCuts.aspxAltKeyList.ZIP
Shortcut Keys In ExcelShortCuts.aspxVBEKeys.ZIP
Shortcut Keys In ExcelShortCuts.aspxXLKeys.ZIP
Shortcut Keys In ExcelShortCuts.htmAltKeyList.ZIP
Shortcut Keys In ExcelShortCuts.htmVBEKeys.ZIP
Shortcut Keys In ExcelShortCuts.htmXLKeys.ZIP
Shuffle ArrayShuffleArray.aspxmodShuffleArray.zip
Fixed Length Strings In VBASizeString.htmmodSizeAndTrim.zip
Sort By ColorSortByColor.aspxmodColorFunctions.zip
Sorting Arrays In VBASortingArrays.aspxmodQSortInPlace.zip
Sorting Arrays Of ObjectsSortingArraysOfObjects.htmmodQSortObjectsInPlace.zip
Sorting Arrays Of ObjectsSortingArraysOfObjects.htmQSortObjectsInPlace.zip
Sorting And Ordering WorksheetsSortWS.aspxmodSortingWorksheets.zip
Retrieving User Specific FoldersSpecialFolders.aspxmodGetUserDirectory.zip
Retrieving Special FoldersSpecialFolders.htmmodGetUserDirectory.zip
SplitEx Alternative To VBA SplitSplit.aspxmodSplitEx.zip
Split On DelimitersSplitOnDelimiters.aspxmodSplitMultiDelims.zip
String ConcatenationStringConcatenation.aspxmodStringConcat.zip
Sum Diagonal Elements Of A RangeSumDiagonal.aspxSumdiagonal.zip
Tables And LookupsTablesAndLookups.aspxLookups2.zip
This is a testTest.aspxRegWorx.zip
Test PageTestPage.aspxRegWorx.zip
Time Zones In VBAtimezone.htmTimeZone.ZIP
Untitled PageTimeZoneAndDaylightTime.aspxmodTimeZones.zip
CPearson.com Topic Indextopic.aspxComAddInInstaller.zip
Tracking Workbook Opens And ClosesTrackingWorkbookOpens.aspxRegWorx.zip
Transparent FormsTransparentForms.aspxmodSetFormOpacity.zip
Truly Global Variables With SetGetPropTrulyGlobalVariables.htmGetSetProp.zip
Truly Global Variables With SetGetPropTrulyGlobalVariables.htmmodGetSetProps.zip
VBA ArraysVBAArrays.htmArraySupport.zip
VBA ArraysVBAArrays.htmmodArraySupport.zip
VBA Shortcut KeysVBAShortcutKeys.htmVBEKeys.ZIP
Creating Menus For The VBA EditorVbeMenus.aspxVBEMenus.zip
Adding Menus To The VBA Editorvbemenus.htmVBEMenu.ZIP
Vector To MatrixVectorToMatrix.aspxRegWorx.zip
Vector To MatrixVectorToMatrix.aspxRowAndColumnToMatrix.zip
Wait For File CloseWaitForFileClose.htmmodWaitForFileClose.zip
Week Numbers In ExcelWeekNumbers.aspxmodWeekNumb ers.zip
Week Numbers In ExcelWeekNumbers.aspxmodWeekNumbers.zip
Week Numbers In ExcelWeekNumbers.aspxWeekNumbers.zip
Weighted Average In ExcelWeightedAverage.aspxRegWorx.zip
Pearson Software ConsultingWhatsNew.aspxCompare.zip
Pearson Software ConsultingWhatsNew.aspxFindAll.zip
Workbook Command BarWorkbookCommandBar.aspxWorkbookCommandBarSetup.zip
Timebombing A WorkbookWorkbookTimeBomb.aspxmodGetSystemErrorMessageText.zip
Timebombing A WorkbookWorkbookTimeBomb.aspxTimeBomb.zip
Temporary Files And FoldersWorkingWithTempFilesAndFolders.htmmodTempFilesAndFolders.zip
VBA Function For WorksheetsWorksheetFunctions.aspxmodSheetFunctions.zip
VBA Function For WorksheetsWorksheetFunctions.aspxRegWorx.zip

Downloadable File List

ShortFadeBar
LastUpdate This page last updated: 21-August-2010.

-->