How does PUP v6 work?
PUP was developed using the programming tools that are supplied with every copy of Excel — the Visual Basic for Applications (VBA) macro language. One of the primary design goals of PUP v6 was simplicity. Consequently, it does not use any custom DLLs or non-standard controls, and it does not make any changes to your system settings (except for settings stored in the Windows Registry). Here’s a basic overview of how the product works: • PUP v6 consists of dozens of add-in files, which use a *.pup extension, rather than an *.xla extension. They are, however, standard Excel add-in files. The *.pup extension is used so these files won’t appear in the Browse dialog box when the Browse button is clicked from Excel’s Add-Ins dialog box. • When the pup6.xla add-in is opened, VBA code builds the PUP v6 menu, and it controls loading and unloading of the utilities. • pup6.xla loads the utilities on an “as needed” basis so they won’t use up memory and system resources if they are not used. • pup6
