This page lists the files available for download.
| Adding The COM Add-Ins Menu Item | AddingCOMAddInsMenuItem.aspx | ComAddInInstaller.zip |
| Alert Message Display Component | Alert.aspx | AlerterSample.ZIP |
| Alert Message Display Component | Alert.aspx | AlerterSetup.zip |
| Alert Message Display Component | Alert.aspx | AlertSetup.zip |
| Alerter Program For Office Developers | Alert.htm | Alert.dll |
| Alerter Program For Office Developers | Alert.htm | AlerterSample.ZIP |
| Application Events | AppEvent.htm | APPEVENT.ZIP |
| Array To Column | arr2col.htm | ARR2COL.ZIP |
| Array Formulas | ArrayFormulas.aspx | ArrayFormulas.zip |
| Automation Add Ins | AutomationAddIns.aspx | ComAddInInstaller.zip |
| Creating Automation Add-Ins In VB6 | AutomationAddins.htm | ExampleAutomationAddIn.zip |
| Color Banding With Conditional Formatting | banding.htm | Banding.zip |
| A Better NETWORKDAYS | BetterNetWorkDays.aspx | modBetterWorkday.zip |
| A Better Union For VBA | BetterUnion.aspx | RegWorx.zip |
| Better Workday | BetterWorkday.aspx | BetterWorkday.zip |
| Better Workday | BetterWorkday.aspx | modBetterWorkday.zip |
| Bits And Bytes | BitsAndBytes.aspx | modBitsAndBytes.zip |
| Browse For Folder | BrowseFolder.aspx | modBrowseFolder.zip |
| CellView Add In | CellView.aspx | CellView.zip |
| Cell View | CellView.htm | CellView.ZIP |
| Character Functions | CharacterFunctions.aspx | RegWorx.zip |
| Special Characters In Excel | chars.htm | symbol.ZIP |
| Class Builder | ClassBuilder.aspx | RegWorx.zip |
| Windows Clipboard | Clipboard.aspx | modClipboard.zip |
| Clone Folder | CloneFolder.htm | modCloneFolder.zip |
| Clone Folder | CloneFolder.htm | modCloneFolderEx.zip |
| Sorting A Collection Or Dictionary | CollectionsAndDictionaries.htm | CollectionsAndDictionaries.zip |
| Sorting A Collection Or Dictionary | CollectionsAndDictionaries.htm | modArraySupport.zip |
| Sorting A Collection Or Dictionary | CollectionsAndDictionaries.htm | modCollectionAndDictionaries.zip |
| Sorting A Collection Or Dictionary | CollectionsAndDictionaries.htm | modQSortInPlace.zip |
| Sorting A Collection Or Dictionary | CollectionsAndDictionaries.htm | QSortObjectsInPlace.zip |
| Color Functions In Excel | Colors.aspx | modColorFunctions.zip |
| Column To Table | ColumnToTable.aspx | ColumnsToTable.zip |
| COM Add-Ins In Excel 2007 | COMAddIn2007.aspx | ComAddInInstaller.zip |
| Creating A COM Add-In In VB6 | ComAddInInVB6.htm | ComAddInInstaller.zip |
| Creating A COM Add-In In VB6 | ComAddInInVB6.htm | ExampleCAIProject.zip |
| Installing COM AddIns | COMAddInsSecurity.aspx | ComAddInInstaller.zip |
| Complete Platform Developement | CompletePlatformDevelopment.aspx | RegWorx.zip |
| Content Banding | ContentBanding.aspx | ContentBanding.zip |
| CPearson.com | ContentTemplate.aspx | RegWorx.zip |
| Creating An XLA Add In | CreateAddIn.aspx | TestAddIn.zip |
| Create GUID | CreateGUID.aspx | RegWorx.zip |
| Creating A COM Add In | CreatingCOMAddIn.aspx | ExampleCOMAddIn.zip |
| Creating A Function Library In .NET | CreatingNETFunctionLib.aspx | MathNET.zip |
| Data Blocks On Worksheets | DataBlocks.aspx | RegWorx.zip |
| Excel Date Functions | DateFunctions1.aspx | DateFunctions1.zip |
| Worksheet Functions For Dates And Times | DateTimeWS.htm | DateInterval.zip |
| Daylight Savings Time | DaylightSavings.htm | modDST.zip |
| Day Of Week Functions | DayOfWeekFunctions.aspx | DayOfWeekFunctions.zip |
| Day Of Week Functions | DayOfWeekFunctions.aspx | modDayOfWeekFunctions.zip |
| Defined Names | DefinedNames.aspx | RegWorx.zip |
| Deleting Duplicate Rows With Advanced Filter | DeleteDupsWithFilter.aspx | modDeleteDupsFilter.zip |
| Deleting Duplicates With Advanced Filter | DeleteDupsWithFilter.htm | modDeleteDupsFilter.zip |
| Language= | DelimitedText.aspx | RegWorx.zip |
| Detecting Scrolling In A Worksheet Window | DetectScroll.htm | ScrollEvents.zip |
| My Dev Box | DevBox.aspx | RegWorx.zip |
| Directory Tree Redirect | DirTree.aspx | RegWorx.zip |
| Distinct Values Function | DistinctValues.aspx | DistinctValues.zip |
| Distributing Days Over Intervals | distribdates.htm | SplitDates.ZIP |
| DLL Name Of COM AddIn | DLLNameOfComAddin.htm | DLLNameOfCOMAddin.zip |
| DLL Name Of COM AddIn | DLLNameOfComAddin.htm | modDLLOfComAddin.zip |
| Document Properties | DocProp.aspx | modDocumentProperties.zip |
| Duplicates In Data In Excel | Duplicates.aspx | Duplicates.zip |
| Easter Calculation | Easter.aspx | RegWorx.zip |
| Empty A Folder | EmptyFolder.htm | modEmptyFolder.zip |
| Enum Name Value List | EnumNameList.aspx | modEnumValueNames.zip |
| Error Hanlding In VBA | ErrorHandling.aspx | RegWorx.zip |
| EveryNth Row | EveryNth.aspx | EveryNth.zip |
| Excel Formulas | excelF.htm | FIRSTL~1.ZIP |
| Excel Formulas | excelF.htm | MINMAX.ZIP |
| Excel Formulas | excelF.htm | RANK.ZIP |
| Excel Formulas | excelF.htm | SUMEVERY.ZIP |
| Excel Formulas | excelF.htm | XLNAMES.ZIP |
| Excel Macros | excelM.htm | HILITE.ZIP |
| Excel Pages | ExcelPages.aspx | GetDistinct.zip |
| Excel Pages | ExcelPages.htm | RowLiner.ZIP |
| Detecting When Excel Shuts Down | ExcelShutdown.htm | modHiddenNames.zip |
| Detecting When Excel Shuts Down | ExcelShutdown.htm | TestExcelShutdown.zip |
| File Extensions In VBA | FileExtensions.aspx | modWindowCaption.zip |
| Changing File Times With VBA | FileTimes.htm | GetSetFileDateTime.zip |
| Changing File Times With VBA | FileTimes.htm | modGetSetFileTimes.zip |
| FindAll VBA Function | FindAll.aspx | modFindAll.zip |
| FindAll XLA Add-In | FindAllXLA.aspx | FindAll.zip |
| FlexLookup | FlexLookup.aspx | FlexLookup.zip |
| FlexLookup | FlexLookup.aspx | RegWorx.zip |
| Directory Tree Listings | FolderTree.aspx | DirTreeSetup.zip |
| Folder/File Tree View | FolderTreeView.aspx | CreatingATreeView.zip |
| GetSystemMessageText | FormatMessage.aspx | modGetSystemErrorMessageText.zip |
| Windows API Function Errors And FormatMessage | FormatMessage.htm | modFormatMessage.zip |
| Extending VBA UserForms | FormControl.aspx | UserFormControl.zip |
| Form Positioner | FormPosition.htm | formposition.ZIP |
| Fractional Arithmetic | FractionalArithmetic.aspx | Fractional.zip |
| Fractional Months | FractionalMonths.aspx | RegWorx.zip |
| Full File Name In Window Caption | FullFileNameInWindowCaption.aspx | RegWorx.zip |
| Excel Games | games.htm | Bingo.ZIP |
| Excel Games | games.htm | dhgames.zip |
| Excel Games | games.htm | MineSweeper.ZIP |
| Excel Games | games.htm | XRay.ZIP |
| Returning Distinct Items In A Range | GetDistinct.aspx | GetDistinct.zip |
| Returning Distinct Items In A Range | GetDistinct.aspx | RegWorx.zip |
| Get FileName | GetFileName.aspx | modGetRecentFile.zip |
| Get FileName | GetFileName.aspx | modRecentFile2.zip |
| GetInfo | GetInfo.htm | GetInfo.ZIP |
| Hidden Name Space | hidden.htm | modHiddenNames.zip |
| Importing Big Text Files Into Excel | ImportBigFiles.aspx | modImportBigFiles.zip |
| Importing Big Text Files Into Excel | ImportBigFiles.aspx | modImportBigFilesFunction.zip |
| Inserting Procedure Name | InsertProcedureNames.aspx | modInsertProcNames.zip |
| Testing If An Array Is Sorted | IsArraySorted.aspx | modIsArraySorted.zip |
| Test If A File Is Open | IsFileOpen.aspx | modIsFileOpen.zip |
| KeyboardShortcuts | KeyboardShortcuts.htm | XLKeys.ZIP |
| Testing Key States | KeyTest.aspx | modKeyState.zip |
| Testing For SHIFT, CTRL, and ALT Keys | KeyTest.htm | modKeyState.zip |
| Last Cell In Range | LastCell.aspx | modLastCell.zip |
| Latitude And Longitude | LatLong.aspx | LatLong.zip |
| Latitude And Longitude | latlong.htm | LATITU~1.ZIP |
| Latitude And Longitude | latlong.htm | LatLongExample.zip |
| Linked List Boxes | LinkedListBoxes.aspx | LinkedListBoxes.zip |
| Linked List Boxes | LinkedListBoxes.aspx | RegWorx.zip |
| ListBox Utilities | ListBoxUtils.aspx | ListBoxUtils.zip |
| ListBox Utilities | ListBoxUtils.aspx | modListBoxUtils.zip |
| ListBox Utilities | ListBoxUtils.aspx | RegWorx.zip |
| List Box Utilities | ListBoxUtils.htm | ListBoxUtils.zip |
| List Box Utilities | ListBoxUtils.htm | modListBoxUtils.zip |
| List Functions | ListFunctions.aspx | Lists2.zip |
| Local And GMT Times | LocalAndGMTTimes.htm | GetSetFileDateTime.zip |
| Local And GMT Times | LocalAndGMTTimes.htm | LocalTimeAndGMT.zip |
| Local And GMT Times | LocalAndGMTTimes.htm | modLocalTimeAndGMT.zip |
| Lookups | lookups.htm | lookup.ZIP |
| Create Multiple Directories | MakeDirMulti.aspx | modMakeMultiStepDirectory.zip |
| Create Multiple Directories | MakeDirMulti.aspx | RegWorx.zip |
| Make Multiple Directories | MakeDirMulti.htm | modMakeMultiDir.zip |
| Matrix To Vector | MatrixToVector.aspx | MatrixToVector.zip |
| Merge Lists To Distinct List | MergeListsToDistinct.aspx | modMergeDistinct.zip |
| Merge Lists To Distinct List | MergeListsToDistinct.aspx | RegWorx.zip |
| Multiple File Import And Export | MultiFileImportExport.htm | VbeImportExport.zip |
| Multiple File Import And Export | MultiFileImportExport.htm | VbeMultiDLL.zip |
| Named Ranges | named.htm | DYNARA~1.ZIP |
| Eliminating Blank Cells In A Range | NoBlanks.aspx | NoBlanks.zip |
| Eliminating Blank Cells From Lists | noblanks.htm | NoBlanks.zip |
| Numbering Lists In Excel | NumberingLists.aspx | RegWorx.zip |
| Working With Times Example Page | overtime.htm | overtime.zip |
| Passing And Returning Arrays With Functions | PassingAndReturningArrays.htm | modArraySupport.zip |
| Playing A Sound In VBA | PlaySound.aspx | RegWorx.zip |
| Testing For Prime Numbers | PrimeNumbers.aspx | Primes.zip |
| Print Multiple Sheets | PrintMultipleSheets.aspx | modPrintMultipleSheets.zip |
| Progress Indictor | Progress.htm | Progressor.ZIP |
| Sorting Arrays With QSort | QSort.htm | modQSortInPlace.zip |
| QSortObjectCompare Example Procedure | QSortObjectCompare.htm | modQSortObjectsInPlace.zip |
| Quick Folder Tree In Excel | QuickTree.aspx | DirTreeSetup.zip |
| Quick Folder Tree In Excel | QuickTree.aspx | modQuickDirTree.zip |
| Quick Folder Tree In Excel | QuickTree.aspx | RegWorx.zip |
| Random Numbers | Random.htm | modRandomNumbers.zip |
| Random Numbers | Random.htm | RandomNumbers.zip |
| Random Numbers In Excel | RandomNumbers.aspx | modRandomNumbers.zip |
| Random Numbers In Excel | RandomNumbers.aspx | RandomNumbers.zip |
| Using The Range Find Method In VBA | RangeFind.htm | modFindUltilities.zip |
| Using The Range Find Method In VBA | RangeFind.htm | Search.zip |
| Ranking Data In Lists | Rank.aspx | Rank2.zip |
| Ranking Data In Lists | rank.htm | RANK.ZIP |
| Recycle A File Or Folder | Recycle.aspx | modRecycleVBA.zip |
| Recycle A File Or Folder | Recycle.htm | modRecycle.zip |
| Registry Functions | Registry.htm | modFormatMessage.zip |
| Registry Functions | Registry.htm | modRegistry.zip |
| Registry Functions | Registry.htm | Registry.zip |
| RegistryWorx | RegistryWorx.aspx | RegWorx.zip |
| Preventing Problems With Worksheet Renaming | RenameProblems.aspx | RegWorx.zip |
| Returning Errors From VBA | ReturningErrors.aspx | RegWorx.zip |
| RowLiner Add-In | RowLiner.htm | RowLiner.ZIP |
| Untitled Page | Sample.aspx | RegWorx.zip |
| SaveCopyAndZip Add-In | SaveCopyAndZip.htm | SaveCopyAndZip.zip |
| SaveCopyAndZip Add-In | SaveCopyAndZip.htm | SaveCopyAndZipSETUP.zip |
| Testing Series Content | SeriesTest.aspx | modSeriesInfo.zip |
| SetFocus For VBA UserForms | SetFocus.aspx | RegWorx.zip |
| SetProp And GetProp | SetGetProp.htm | GetSetProp.zip |
| SetProp And GetProp | SetGetProp.htm | modGetSetProps.zip |
| Pearson Software Consulting | SetParent.aspx | SetParent.zip |
| VBA Function For Worksheets | SheetNameFunctions.aspx | modSheetFunctions.zip |
| VBA Function For Worksheets | SheetNameFunctions.aspx | RegWorx.zip |
| Shell And Wait | ShellAndWait.aspx | modShellAndWait.zip |
| Shell And Wait, Simple And Enhanced | ShellAndWait.htm | modShellAndWaitEnhanced.zip |
| Shell And Wait, Simple And Enhanced | ShellAndWait.htm | modShellAndWaitEnhancedVB6.zip |
| Shell And Wait, Simple And Enhanced | ShellAndWait.htm | modShellAndWaitSimple.zip |
| Shell And Wait, Simple And Enhanced | ShellAndWait.htm | modShellAndWaitSimpleVB6.zip |
| Shell And Wait, Simple And Enhanced | ShellAndWait.htm | ShellAndWait.zip |
| Shell And Wait, Simple And Enhanced | ShellAndWait.htm | ShellAndWaitEnhanced.zip |
| Shell And Wait, Simple And Enhanced | ShellAndWait.htm | ShellAndWaitSimple.zip |
| Shell And Wait, Simple And Enhanced | ShellAndWait.htm | ShellAndWaitVB6.zip |
| Shortcut Keys In Excel | ShortCuts.aspx | AltKeyList.ZIP |
| Shortcut Keys In Excel | ShortCuts.aspx | VBEKeys.ZIP |
| Shortcut Keys In Excel | ShortCuts.aspx | XLKeys.ZIP |
| Shortcut Keys In Excel | ShortCuts.htm | AltKeyList.ZIP |
| Shortcut Keys In Excel | ShortCuts.htm | VBEKeys.ZIP |
| Shortcut Keys In Excel | ShortCuts.htm | XLKeys.ZIP |
| Shuffle Array | ShuffleArray.aspx | modShuffleArray.zip |
| Fixed Length Strings In VBA | SizeString.htm | modSizeAndTrim.zip |
| Sort By Color | SortByColor.aspx | modColorFunctions.zip |
| Sorting Arrays In VBA | SortingArrays.aspx | modQSortInPlace.zip |
| Sorting Arrays Of Objects | SortingArraysOfObjects.htm | modQSortObjectsInPlace.zip |
| Sorting Arrays Of Objects | SortingArraysOfObjects.htm | QSortObjectsInPlace.zip |
| Sorting And Ordering Worksheets | SortWS.aspx | modSortingWorksheets.zip |
| Retrieving User Specific Folders | SpecialFolders.aspx | modGetUserDirectory.zip |
| Retrieving Special Folders | SpecialFolders.htm | modGetUserDirectory.zip |
| SplitEx Alternative To VBA Split | Split.aspx | modSplitEx.zip |
| Split On Delimiters | SplitOnDelimiters.aspx | modSplitMultiDelims.zip |
| String Concatenation | StringConcatenation.aspx | modStringConcat.zip |
| Sum Diagonal Elements Of A Range | SumDiagonal.aspx | Sumdiagonal.zip |
| Tables And Lookups | TablesAndLookups.aspx | Lookups2.zip |
| This is a test | Test.aspx | RegWorx.zip |
| Test Page | TestPage.aspx | RegWorx.zip |
| Time Zones In VBA | timezone.htm | TimeZone.ZIP |
| Untitled Page | TimeZoneAndDaylightTime.aspx | modTimeZones.zip |
| CPearson.com Topic Index | topic.aspx | ComAddInInstaller.zip |
| Tracking Workbook Opens And Closes | TrackingWorkbookOpens.aspx | RegWorx.zip |
| Transparent Forms | TransparentForms.aspx | modSetFormOpacity.zip |
| Truly Global Variables With SetGetProp | TrulyGlobalVariables.htm | GetSetProp.zip |
| Truly Global Variables With SetGetProp | TrulyGlobalVariables.htm | modGetSetProps.zip |
| VBA Arrays | VBAArrays.htm | ArraySupport.zip |
| VBA Arrays | VBAArrays.htm | modArraySupport.zip |
| VBA Shortcut Keys | VBAShortcutKeys.htm | VBEKeys.ZIP |
| Creating Menus For The VBA Editor | VbeMenus.aspx | VBEMenus.zip |
| Adding Menus To The VBA Editor | vbemenus.htm | VBEMenu.ZIP |
| Vector To Matrix | VectorToMatrix.aspx | RegWorx.zip |
| Vector To Matrix | VectorToMatrix.aspx | RowAndColumnToMatrix.zip |
| Wait For File Close | WaitForFileClose.htm | modWaitForFileClose.zip |
| Week Numbers In Excel | WeekNumbers.aspx | modWeekNumb ers.zip |
| Week Numbers In Excel | WeekNumbers.aspx | modWeekNumbers.zip |
| Week Numbers In Excel | WeekNumbers.aspx | WeekNumbers.zip |
| Weighted Average In Excel | WeightedAverage.aspx | RegWorx.zip |
| Pearson Software Consulting | WhatsNew.aspx | Compare.zip |
| Pearson Software Consulting | WhatsNew.aspx | FindAll.zip |
| Workbook Command Bar | WorkbookCommandBar.aspx | WorkbookCommandBarSetup.zip |
| Timebombing A Workbook | WorkbookTimeBomb.aspx | modGetSystemErrorMessageText.zip |
| Timebombing A Workbook | WorkbookTimeBomb.aspx | TimeBomb.zip |
| Temporary Files And Folders | WorkingWithTempFilesAndFolders.htm | modTempFilesAndFolders.zip |
| VBA Function For Worksheets | WorksheetFunctions.aspx | modSheetFunctions.zip |
| VBA Function For Worksheets | WorksheetFunctions.aspx | RegWorx.zip |