System iNetwork - Microsoft Excel and Microsoft Word for IBM i Developers

Files available for download

Note: use the course password to open PDF files

File Name Description
Meeting 1: IBM i Access for Windows Database Providers and Tools
Meeting1.pdf Presentation for Meeting 1.
 
Verify_IBMiAccess_V5Rx.pdf How to verify the features of IBM i Access that are installed on your PC. Use this document if you are using one of the V5Rx versions of iSeries Access or System i Access for Windows (V5R1, V5R2, V5R3, V5R4).
 
Verify_IBMiAccess_V6Rx.pdf How to verify the features of IBM i Access that are installed on your PC. Use this document if you are using the V6R1 version of IBM i Access or the V7R1 version of IBM i Access.
 
Meeting 2: Excel Session 1 - Getting data from your IBM i into Excel
ExcelWord_Meeting2.pdf Presentation for Meeting 2.
 
ExcelWord_Lab2.pdf Lab for Meeting 2.
 
Meeting 3: Excel Session 2 - Work with data-driven macros in Excel
ExcelWord_Meeting3.pdf Presentation for Meeting 3.
 
ExcelWord_Lab3-2003.pdf Lab for Meeting 3. Use this lab for Excel 2003.
ExcelWord_Lab3-2007.pdf Lab for Meeting 3. Use this lab for Excel 2007 and Excel 2010.
 
Meeting 4: Word Session 1 - Getting data from your IBM i into Word
ExcelWord_Meeting4.pdf Presentation for Meeting 4.
 
ExcelWord_Lab4-2003.pdf Lab for Meeting 4. Use this lab for Word 2003.
ExcelWord_Lab4-2007.pdf Lab for Meeting 4. Use this lab for Word 2007 and Word 2010.
 
Meeting 5: Word Session 2 - Create Word forms to work with data on your IBM i
ExcelWord_Meeting5.pdf Presentation for Meeting 5.
 
ExcelWord_Lab5-2003.pdf Lab for Meeting 5. Use this lab for Word 2003.
ExcelWord_Lab5-2007.pdf Lab for Meeting 5. Use this lab for Word 2007 and Word 2010.
 
ITHelpDocVBA.txt Visual Basic for Applications code file used for Lab 5.
If possible, download this file and print it out before the online meeting. I will be referring to this code example during the meeting.