| Sample |
Demonstrates |
| aliases |
- Field Marker Aliases. These are very powerful and simple. They
are used to isolate your Source Workbook from the structure of
the underlying data.
- Odd/Even Row Colors (using Conditional Formatting)
- Word Wrap
|
| autofilter |
- Excel AutoFilters (Excel Menu: Data | Filter | AutoFilter)
- The Excel SubTotal, Max, Min, Average and CountA Functions
|
| bank |
- Positioning of Multiple RecordSets into different spots on the same Sheet.
- Multiple RecordSources on the same Excel row.
- Sum (Total) of a Field in a RecordSet. This can be applied to any formula.
- Using Variable Field Markers and Live Data (RecordSet) Field Markers on the same Sheet.
|
| charts |
- Many kinds of Charts.
- Chart with Data Table (see "Bar Chart" Sheet)
|
| condfmt |
- Conditional Formatting
|
| debt |
- Multiple RecordSet Queries
- The >>$Now Standard Field Marker
- Sum (Total) of a Field in a RecordSet. This can be applied to any formula.
|
| housepics |
- Excel 5.0/95 Workbook
- Dynamic Picture Insertion (Picture Field Markers)
(pulling JPEGs from an access database)
|
| index_markers |
- Inserting Fields by Index Number
- Field Name Markers (to insert Field's Name by Index Number)
- This can be used to insert an unknown number of fields.
- Using the Format Cells method to format the Date data that has
been inserted.
- Using the ClearCells method and the HideSheet method to "cleanup"
the Source Workbook. (ie. to remove the extra Field Markers and
cells that are not used)
|
| listbox |
- List Box and other Forms Controls (like ComboBoxes)
- Named Ranges
- The OFFSET Function
- The HideSheet Method
|
| merge |
- Merged Cells
|
| outline |
- Use of outlines
- Inserting over 900 rows of data.
- Inserting Boolean Values
|
| pivot |
- Creating PivotTables and PivotCharts from dynamically inserted data.
|
| repeat |
- Excel 5.0/95 Format Workbook
- Repeating data from the same RecordSet many times on the same Sheet
|
| states |
- Referencing another Sheet
- Write Data from Left to Right, Across the Sheet
- Charts
- Pictures, Text Boxes
- Frozen Panes
- Comments
|
| vba |
- using VBA in Excel Workbook
- use of Named Ranges (Defined Names)
|
| vba_autofit |
- running VBA code on Workbook open
|
| vba_orders |
- Calculating Formulas on inserted data using VBA and Macros
- Named Ranges (Defined Names)
- Inserting over 800 rows of Data
- Western European language characters (see Shipname column)
|