page
176
PalmPilot Handbook
■
Place a copy of your custom Expense Report in the folder
named “template” (in the PalmPilot Desktop directory).
Change the file name so it has the file extension .xlt (which
defines it as a Microsoft Excel Template). Make a note of the
exact file name so it can be defined in the mapping table file.
Programming the Mapping Table
Once you have analyzed the components of your custom Expense
Report, you can program the mapping table to fill the report with
data from the PalmPilot.
To program a new custom mapping table:
1.
In Microsoft Excel, open a copy of the file named
Maptable.xls. This file is located in the same folder
(subdirectory) as the PalmPilot Desktop 2.0 application. Make
a backup copy of this file before you make your modifications.
2.
Mapping a new template. Scroll to where you find the name
of the original template that you chose for your modifications.
The name of the template will appear in column B of the
Maptable.xls file, next to the cell highlighted in green that
reads “Template Name:”. If you did not modify an existing
template, move to any table in the Maptable.xls file.
3.
Select all the rows associated with the template name. To
select the rows, click and drag on the row numbers (left side),
so they appear highlighted as shown in the following diagram:
Summary of Contents for PalmPilot
Page 1: ...PalmPilot Handbook ...
Page 52: ......
Page 118: ......
Page 142: ......
Page 170: ...page 168 PalmPilot Handbook Sample 2 ...
Page 171: ...Appendixes page 169 Sample 3 ...
