| |
|
| To try this example: |
| |
| If you would like to try this
example, click here to download a
Winzip file which contains: |
| - MilestonesOLEExcelExample3.xls - The Excel
spreadsheet with data and program |
| - ExcelTemplate3.mtp - The
Milestones Professional template used by the program |
| |
| If you would like to try this
example, do this: |
| 1 |
|
Download the MilestonesOLEExcelExample3.zip
file |
| 2 |
|
"Unzip" the file to a
folder on your computer. |
| 3 |
|
Copy the Template
(ExcelTemplate3.mtp)
to your Milestones Professional Personal template folder. |
| 4 |
|
Start Excel and open the
ExcelExample.xls file. |
| 5 |
|
In Excel, choose Macro on the Tools
menu, then choose Macros. |
| 6 |
|
Click to select the "CreateOutlinedSchedule"
macro. |
| 7 |
|
Click the run button. |
|
| |
| (This download is recommended
for those familiar with Visual Basic and Microsoft Excel). |
|
| Note: The
DataGraph and ValueSet are defined in the template and are automatically
generated using the numbers in the "Mail Qty" Column. The
numbers are spread over the duration of the task's time frame. |
|
|
