Chapters list - Excel VBA to IBM i - Data migration guide
Excel VBA to IBM i: Chapter 1 - Excel VBA Programming
(1) VBA - Overview
(2) Excel Interface design
(3) VBA program source Editor
(4) VBA Example -1: Accessing Worksheet properties
(5) VBA Example -2: Accessing cells properties of other Sheet - Sheet2
(6) VBA Example -3: Accessing properties of Active worksheets
(7) VBA Example -4: Activate worksheet to access its element properties
(8) VBA Example -5: Read values of excel cell in VBA program
(9) VBA Example -6: Write a value to excel cell using VBA program
(10) VBA Example -7: To concatenate variables in VBA
(11) VBA Example -8: Conditional statement - If … Else…Else If
(12) VBA Example -9: For loop in VBA
(13) VBA Example -10: ‘Do While’ loop in VBA
(14) VBA Example -11: Renaming button & procedure in VBA
(15) VBA Example -12: Using Excel built-in VBA functions
(16) VBA Example -13: Using Array in VBA
(17) VBA Example -14: Call VBA functions/ sub-procedure from main procedure
(18) VBA Example -15: Using VBA functions to return value to main procedure
(19) VBA Example -16: Event handling in VBA
(20) VBA Example -17: Excel Application properties in VBA
(21) VBA Example -18: Make database connection in VBA
(22) VBA Example -19: Error handling in VBA
(23) VBA Example -20: Drop down list in VBA
(24) VBA Example -21: Debug program in VBA
Excel VBA to IBM i: Chapter 2 - Download data from IBM i to Excel
Q1. VBA Example - Download data from IBM i to Excel
Excel VBA to IBM i: Chapter 3 - Upload data from IBM i to Excel
(1) VBA Example - Upload data from IBM i to Excel
Excel VBA to IBM i: Chapter 4 - Call IBM i programs from Excel VBA
(1) VBA Example -1: Call IBM i programs from Excel VBA
(2) VBA Example -2: Call IBM i programs with parameters from Excel VBA