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 |