Click a button and watch an iSeries file open in Excel
For a two minute overview of this training click play.
Does not require ODBC configuration on the PC or other complicated steps. No software to buy. If you have an iSeries and Microsoft Excel, you are good to go!
Quickly and easily modernize iSeries reporting with Microsoft Excel with the iSeries. This is practical training developed in a real working environment and used on a daily basis.
Here is what you will learn:
How to get any iSeries database 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 on 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.
This course comes with an illustrated manual and a CD containing all the exercise source code, a complete Excel workbook with buttons to run queries and a sample user request workbook for creating clearly defined user requests that will make your job easier.
Skill Level: Some experience with computer programming and OS/400 DB2 database. Any RPG programmer with 1 or more years of experience will be able to successfully complete this course. Some Microsoft Office Suite experience a plus. This course is not intended for end-users or for novice programmers.