Rewrite of the Excel Pivot Tables UDF

[water]

I have started to rewrite the Excel Pivot Tables UDF with the following goals:

• Function headers should adhere to the UDF specification.
• Magic numbers should be replaced by constants used by MS.
• I would like to rename function names so they start with the object name (SCRIPT BREAKING CHANGE). e.g. _ExcelPivot_CreateCache becomes _ExcelPivot_CacheCreate.
  So you can easily see which functions are provided by the UDF for each Pivot object.
• Sensible default values for parameters should be added (similar to the Excel UDF) e.g. If Range is not specified the UsedRange property is used.
• Parameters should allow multiple formats e.g. Worksheet can be the name, the index or the worksheet object.
• Error handling should be enhanced so @error and @extended are set. The function header documentation should be extended.
• The documentation for the UDF should be available as CHM so it can be added to the Advanced Help tool.
• A COM error handler should be added.