Dynamic Text
Below is a list of Dynamic Text reference materials with details about what they provide. To view these references simply click on the link for the desired document and in the dialog that pops up either open or save to disk. Some of the documents are PDF files which open with Adobe Acrobat.
Getting Started with Dynamic Text
This document provides an essential starting point for using Dynamic Text. It covers the basic Dynamic Text code structure, exporting StyleADVISOR charts to Graph Rectangles in a Microsoft Office document, and exporting specific StyleADVISOR values to a Microsoft Office document that contains Dynamic Text.
Sample Dynamic Text
This StyleADVISOR workbook contains sample Dynamic Text and illustrates incorporating Dynamic Text directly into a StyleADVISOR workbook. It focuses on customizing titles and changing information displayed in a StyleADVISOR workbook. Additionally, all of the code in this workbook can be copied and pasted directly into another StyleADVISOR workbook.
Dynamic Text Code Bank
This Excel spreadsheet contains dynamic text code examples to pull information from a standard StyleADVISOR Manager Analysis workbook. Each of the Excel worksheets contains the StyleADVISOR table name, unformatted dynamic text code, formatted dynamic text code, and a sample of the formatted output. All of the dynamic text (formatted or unformatted) can be copied and used as it is, provided the code is used in conjunction with a standard StyleADVISOR Manager Analysis workbook for exporting.
Number Formatting in Dynamic Text
This document provides information on the different methods of formatting numbers in Dynamic Text. It details examples of the formatting variables, including trailing digits, leading digits, thousand, and percent. It also addresses setting default number formatting for all Dynamic Text in a StyleADVISOR workbook.
Date Formatting in Dynamic Text
This document provides information on the different methods of formatting dates in Dynamic Text. It covers examples of the formatting variables, including day, month, quarter, and year time periods. It also includes examples of ordinal dates (2nd, 3rd, 4th) and setting default date formatting for all Dynamic Text in a StyleADVISOR workbook.
Debugging Dynamic Text
This document provides several different methods and techniques for debugging Dynamic Text issues. It is an invaluable reference for troubleshooting Dynamic Text problems. It highlights simplifying code, displaying additional information, hardcoding variables, and checking data types and data lengths.
Workbook Functions in Dynamic Text
This document covers the exceptionally powerful Dynamic Text tool Workbook Functions. It details what workbook functions are, how they are used, how and why to write them, and finally how to best implement them. If your Dynamic Text code has moved beyond pulling statistics with Value(), this document will be invaluable for simplifying your work.
String Manipulation in Dynamic Text
This document provides information on the different methods of manipulating strings in Dynamic Text. It highlights and shows detailed examples of Find, Replace, and Concatenation, and covers some of the lesser used DT manipulation functions including Length, WrapText, and Combine. It also includes an example of how to make code that can handle mixed case characters.
Conditional Logic in Dynamic Text
This document addresses conditional logic, also known as If/Then statements. It starts with the basics and simple examples, then builds to complicated tests. Conditional logic is a tool that every DT user needs to understand and have in their tool box.
Looping in Dynamic Text
This document gets to the heart of the three ways to create loops in Dynamic Text; For, While, and Repeat Until. It also provides detailed working examples of each.