- Corrected date handling and parsing
- Factored code to reduce redundancy (DRY)
- Expanded field handling
- Improved equations that create outline indentations

- The Reformat module iterates the columns of the active sheet, performs replacements for things like days, and reformats numeric fields to be more usable.
- The PrintFormat module sets the orientation to Landscape, fits the page to 1 wide by 99 long, and then sets the first row to repeat.

- Data delivery
- Project

The Microsoft.Office.WebExtension namespace (which by default is referenced using the alias Office in code) contains objects you can use to write script that interacts with content in Office documents, worksheets, presentations, mail items, and projects from your apps for Office.

- Get primary divisors
- Get upper and lower bounds of secondary
- Get larger ABS(max) or ABS(min)
- Multiply (max/min) divisor by numbers (1,2,5,10,20,25,30) to find the first multiplier larger than current
- Apply multiplier to major unit
- Apply min to min (min divisors x minor unit)
- Apply max to max (max divisors x major unit)

- Get primary divisors
- Get upper and lower bounds of secondary
- Get larger ABS(max) or ABS(min)
- Multiply (max/min) divisor by numbers (1,2,5,10,20,25,30) to find the first multiplier larger than current
- Apply multiplier to major unit
- Apply min to min (min divisors x minor unit)
- Apply max to max (max divisors x major unit)

- Get primary divisors
- Get upper and lower bounds of secondary
- Get larger ABS(max) or ABS(min)
- Multiply (max/min) divisor by numbers (1,2,5,10,20,25,30) to find the first multiplier larger than current
- Apply multiplier to major unit
- Apply min to min (min divisors x minor unit)
- Apply max to max (max divisors x major unit)

- Iterating the Acrobat object model
- Accessing the JSObject
- Accessing components via the JSObject

- Process Capability (4)
- Proportion Defective (4)
- Number Defective (3)

Collection Functions

- IsInCollection
- SortCollection
- BuildRowCollection
- BuildCollectionFromRange
- BuildRowCollectionFromRange
- BuildRowCollectionFromWorksheet
- ReturnValueFromCollectionOfRows

- UniqueItems
- TransposeArray

The project includes multiple methods:

C-Sharp form, printing and formatting options

- void PrintFormat();
- void PreviewThis();
- string SelectFolder(string defaultPath);

- string GetDbsToString(string server);
- bool VerifyConnection(string server, string db, string cube);
- bool ModifyConnections(string server, string db, string cube);

- void RefreshWorkbookPivots(_Workbook workbook);
- void RefreshThisPivot(PivotTable table);
- void RefreshSheetPivots(_Worksheet worksheet);

This is an update C# add-in that exposes static methods using Excel-dna.

- Write a sub that asks the user for an integer such as 100 and stores it in the variable "upperLimit".
- It then asks the user for another integer such as 3 and stores it in the variable "factor".
- It then creates an array called "multiple", of the appropriate size, that contains all the multiples of factor no greater than upperLimit.
- Finally, it uses a loop to sum all of the elements in the array and reports this sum with an appropriate message in a message box.
- For example, if the two inputs are 100 and 3, it should report "The sum of multiples of 3 no greater than 100 is 1683".

In the first:

- create an array of [upper limit] / [factor] elements, called upper bound or ubound, in this case 33
- iterate through the array from array(1) to array (ubound), summing the elements e.g, 3 + 6 + .... + 99, to get 1683

- Calculate the number or elements, e.g., the integer value of [upper limit] / [factor], or 33
- Calculate the highest value, 99
- Sum the highest and lowest values, 102
- multiply the sum times 1/2 the number of elements, 16.5, to get 1683

Properties

- Output Name
- Output Path
- File Names (as single dimension array or single item)

- Create Method
- Add Method (accepts full path of single item)

- Function Name: Fx_NextWorkday
- Variables:
- StartDate, a date
- Increment, number of hours or days
- IncrementType, hours (1) or days (2)
- Return: Date

Please note that you will need to modify macro security to enable "Trust access to the Visual Basic project" via the menu (Tools | Macro | Security... | Trust Sources).

- One that copies the recordset en masse
- The other that copies the recordset on a cell by cell basis