NorthWall Applications

All the code files below are available on GitHub

AddRecordsToTable

ado Recordset to array

ADOExcelSQLServer

aggregateFigures

aggregateFiguresFormatting

ALL USERFORM CONTROLS

All Windows Apis

AllMarketData ControlledbyMenu

ANIMATED CHARTS

ApostrophieFunction

AppendtoTextFile

APPLICATION EVENT TRACKER

APPLICATIONEVENTTRACKER

ApplicationTracker

Array Functions

AssetCorrelation

AutoCorrectObject

backup 000WebHelpers

BreakExternalLinks

BUDGET PIVOT TABLE

Build ZillowMasterData

CellFormatObject

CELLTYPE FUNCTION

CHANGE USERFORM SIZE

CharactersObject

CHART ACTIVE CELL

CHART IMAGE MAP

CHART IN USERFORM

CHART TO GRAYSCALE PICTURE

ChildSheetsUpdated

ClipBoardFunctions

Close ImmediateWin

CollectionandDictionaryProcs

COLOR CONVERSION FUNCTIONS

CombineAllTables

COMMISSION CALC

COMMISSION FUNCTIONS

configSheetMacros

ConnectSqlServer

CONTROL PANEL DIALOGS

COPY MULTIPLE SELECTION

CopyAllModules Revised

COPYGOOFINCOMPANY

CopyUserForm to Workbook

CREATE ADD MODULE

CREATE FILE LIST

CREATE HYPERLINKS

CREATE USERFORM ON THE FLY

CreateWorkSelChangeEvent

CustomPropertyObject

Database Queries

Database Reports

DATE AND TIME PICKER

DebugPrintModules

DELETE EMPTY ROWS

Delete Temp Files Primitive

DeleteEmptyModules

DeleteModuleCode

DownloadInternetFiles

DownloadOutlookAttachments

draft SaveFileAs

DRIVE INFORMATION

Drop Make AllZillowTables

Drop Make AllZillowTables2

DYNAMICDATACONNECTION

DynamicPasswordCrackFunction

EFFICIENT LOOPING

EMULATE TASK PANE

EQUIPMENTLISTSLICERS

Errors in Arrays

EVENTS EMBEDDED CHART

EXCEL LIGHT BOX

EXPORT ALL GRAPHICS

EXPORT AND IMPORT CSV

ExportChildData 1

ExportChildWorkBooks

ExportChildWorkBooks Backup

ExportModulesGREAT

ExportModulesInActiveWorkbook

ExportToChildsV2

EXTENDED DATE FUNCTIONS

ExtractEmailFromStrings

ExtractHyperLinks

ExtractHyperLinks2

ExtractWebPageTable ProcessTags

fetchingProfiles

fetchingProfiles2

FILE ASSOCIATION

FILE INFORMATION

FileAttributesFromFolder

FileCopyAndKill

FileLenFunction

FillFileNamesFromList

FILTER TEXT FILE

Finance MoveData

FindKeyword Function

FindMaxLongValue

ForEachNextLoop

FORMAT ALL CHARTS

FormatConditionObject

formattingMacros

FullContactSocialMediaAPI

GENERATE THEME COLORS

GET SERIES RANGES

GETACOLOR FUNCTION

GetAllFiles HyperlinkFiles

GetAllFiles RecursiveDir

GetAllFilesandFolders

GetAllxlsmCodeFiles

GetAttrFunction

GetFilePathFromString

GetInnerTextofHTML

GetLocalIp Addresses

GetMailFromOutlook

GetOutlookAttachements

GetOutputFolder

GetXML Products SiteMaps

GetXML Products SiteMaps 2

HIDE AND UNHIDE SERIES

HIDE COLUMNS BEFORE PRINTING

HIDE ROWS AND COLUMNS

HidePasswordInputs

HYPOCYCLOID ANIMATED

IgetTheModulesNow

ImportChildData 1

ImportCSVfiles Backup

ImportStackOverFlowData

ImportTablesToAccess

IndividualWorkbook

INPUTBOX METHOD

INRANGE FUNCTION

IsArray Function

L and UBound Function

LIST ADD REMOVE CmdBars

LIST ADD IN INFORMATION

LIST ALL PROCEDURES

LIST VB COMPONENTS

ListAllModules And Procedures

ListAllProcedures

LISTBOX ACTIVATE SHEET

LISTBOX ITEM TRANSFER

LISTBOX MOVE ITEMS

LISTBOX MULTICOLUMN1

LISTBOX MULTICOLUMN2

LISTBOX MULTIPLE LISTS

LISTBOX SELECT ROWS

LISTBOX SELECTED ITEMS

LISTBOX UNIQUE ITEMS1

LISTBOX UNIQUE ITEMS2

ListFileandFolders Reccursive

ListFilesandFolders Recursion

ListFilesInFolder

ListModules InWorkbook

ListModules Procedures

ListSelected PDF Files

LOG WORKBOOK OPEN

LogTable Standardize

LOOP VS ARRAY FILL RANGE

LoopFolderChangeExtension

MAKE XL 2003 MENUS

MANIPULATEXMLPARTS

MarketWatch Options

MasterSheet DropDowns

MasterSheet DropDowns Backup

MatchText FuzzyLookup

MedlineImageFiles

MedlineScrape WORKS

MedlineSearchProduct

MESSAGE BOX EXAMPLES

Method CopyFromRecordset

Method OpenDatabase

Method TransferSpreadsheet

modArraySupport

modBrowseFolder

MODELESS USERFORM1

MODELESS USERFORM2

modGetSystemErrorMessageText

modGetUserDirectory

modListPrinters

MOUSEOVER EVENT EMBEDDED

msnStockQuoteQueries

MULTILINGUAL WIZARD

MULTIPAGE CONTROL DEMO

MULTIPLE BUTTONS

NAME RANGES AGAIN

NEXT EMPTY CELL

NO SHORTCUT MENUS

OLD STYLE TOOLBAR

ONKEY EVENT DEMO

ONTIME EVENT DEMO

OpenFileorFolderMethod

OpenOutLookOrBindifOpen

OpenPDFandConvertToWord

OpenWorkbookInstallAddin

OptionTradingWorkbookFunctions

PAGE BREAK DISPLAY

ParameterArrays

PassingArraysToFunctions

PassWordBreaker

PDFtoExcel Scrape

PERSONALIZED EMAIL OUTLOOK

PERSONALIZED EMAIL OUTLOOK (LATE BINDING)

PRACTICE APPLICATIONEVENTS

PRACTICE CONTEXTMENU

PRACTICE DATAMODEL

PRACTICE EXCEL20

PRACTICE EXCEL22

PRACTICE EXCEL23

PRACTICE EXCEL23B

PRACTICE EXCEL23C

PRACTICE EXCEL23D

PRACTICE EXCEL24

PRACTICE EXCEL26

PRACTICE EXCEL27

PRACTICE EXCEL30

PRACTICE EXCEL30B

PRACTICE MODIFYQAT

PRACTICE MODIFYRIBBON

PRACTICE PIVOTREPORTEVENTS

PRACTICE RIBBONCUSTOMIZATION1

PRACTICE WORKSHEETEVENTS

PrintMyEnvironments

processKeyPress

PROGRESS INDICATOR1

PROGRESS INDICATOR2

PROGRESS INDICATOR3

PROMPT FOR A RANGE

PROMPT FOR FILE

publicFunctions

QUERY TABLE EVENTS COMPLETE

QUERYCLOSE DEMO

queryManagement

QueryTableListObj

QuickChangePrinter

RANDOM NUMBER GENERATOR

RANGE SELECTION DEMO

ReadXMLintoExcel

RelocateAsAddin

RemovePasswords

RESIZABLE USERFORM

RESIZABLE USERFORM API

REVERSE PIVOT TABLE

RIBBON CONTROLS DEMO

RIBBON MODIFICATION

Rst Disconnected

RUNNING AN ACCESS MACRO FROM EXCEL

RUNNING AN ACCESS QUERY FROM EXCEL

SaveEmailAttachmentsToFolder

SaveOutlookAttachments

SavePDFOtherFormat

ScrapeFreelancer

ScrapeHTML Tables

ScrapeMedlineUpdated

ScrapeMedlineUpdated 3

SCROLLING CHART

SeeIfInternet IsConnected

SELECT BY VALUE

SEMITRANSPARENT USERFORM

SEND PDF VIA OUTLOOK

SENDING ALL EXCEL CHARTS TO A POWERPOINT PRESENTATION

SENDING EXCEL DATA TO A POWERPOINT PRESENTATION

SENDING EXCEL DATA TO A WORD DOCUMENT

SendKeysStatement

SetRangeNames 1

SetRangeNames 3

SHAPE OBJECT COLORS

SHELLEXECUTE EXAMPLES

SHORTCUT WITH SUBMENU

SHOW SHORTCUT MENU ITEMS

SHOW SHORTCUT MENU NAMES

SIMPLE ADO EXAMPLE

SIMPLE ADO EXAMPLE2

SIMPLE PIVOT TABLE

SIMPLE UNDO DEMO

SIMULATED TOOLBAR

SIMULATING MAIL MERGE WITH A WORD DOCUMENT

SIZE AND ALIGN CHARTS

SLIDING TILE PUZZLE

SPARKLINE REPORT

SPELLDOLLARS FUNCTION

SpellingOptionsObject

SPINBUTTON AND TEXTBOX

SPINBUTTON EVENTS

splitByDimensions1

splitByDimensions2

splitByDimensions3

splitByDimensions4

splitByDimensions5

splitByDimensions6

StandardProcedures

START CALCULATOR

StockOptionFunctions

stripLeadingSlashes

stripTrailingSlashes

SURVEY DATA PIVOT TABLES

SYNCHRONIZE SHEETS

TempFilesandFolders

templateCorrected 1

templateCorrected 3

TestForWordandOutlook

TimeSeriesCorrelationCharts

TimeSeriesCorrelationCharts 2

TimeSeriesCorrelationCharts2

TimeSeriesDecomp

TINTANDSHADE DEMO

UniqueItems Function

UniqueItems Table Function

UnzipMultipleFiles

UpdateTemplates

URL HTML StaticQuery

USERFORM EVENTS

v2 ListSelected PDF Files

VARIANT TRANSFER

VBA Adobe ReadWrite PDFs

VBA CLOCK CHART

VBA UTILITY FUNCTIONS

VbaWebInstaller

WINDOWS DIRECTORY

WINDOWS REGISTRY

WordDoc Manipulation

WorkingWith IE HTML

WORKSHEET FUNCTIONS

YahooCurrencyandCommodityQuery

yahooStockIndexQuery

ZillowHousingFilePathSortData

ZOOM AND SCROLL SHEET