| Reference |
Format |
Date |
Size |
|
- 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.
|
- 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.
- Download the zipped
file here.
|
- 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.
|
- 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.
|
- 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.
|
- 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.
|
- 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.
|
- 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.
|
- 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.
|
- 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.
|
- This document
provides some "best practices" for writing Dynamic Text code. One of
the major complications with code (for any programming language) is making it
legible for others. As important is making it fully understandable to yourself
should you need to revisit it several months or years later. This documents offers
some suggestions to avoid common pitfalls in this area. It address commenting,
spacing, formatting, naming, and many other very useful suggestions. It's a must
read for any DT "programmer!"
|
- This document
covers using Dynamic Text in StyleADVISOR
to reference information from an Excel spreadsheet. It provides an example of
pulling Top 10 Holdings information from Excel into a StyleADVISOR
workbook.
|
