|
Here is what you will learn:
- How to get any file into an Excel spreadsheet.
- How to use Query/400 to “filter”
what records to put into Excel.
- How to use the AS/400 IFS to copy information
into Excel.
- How to call programs on the iSeries from your
PC using RMTCMD.
- How to use Visual Basic in Excel to run a
program on the iSeries and open the results
in Excel.
- How to pass parameters to called programs
on the iSeries right from Excel.
- How to modify fonts, column widths, lock titles,
set formatting and more . . . all automatically,
once an iSeries file is opened in Excel.
- How to build Query/400 queries and never have
to change them again to select different date
ranges.
- How to click a button in Excel and open other
PC programs, other spreadsheets, even web-sites.
|
| |
|
|
|
| If
you have iSeries Access (Client Access) and Microsoft
Office you already have everything you need. |
| |
| Note:
This is practical training developed in a real iSeries
working environment and used on a daily basis. |
|
| |
For fastest service call
1-805-807-6150 |
| |
 |
|
Labs,
How-tos
and
Step-by-step
Instruction! |
|
| |
| Work
Smart |
| Order
Microsoft Excel with the iSeries for a free
15-day examination. Look the materials over without cost
or obligation. If you are not 100% satisfied return the
training along with our invoice. You have no risk or obligation.
Price: $495 plus $9.75 S&H in Continental US.
|
| |
|
