Chapters list - Excel VBA to IBM i - Data migration guide

Below topics have been convered in Excel VBA to IBM i eBook. To buy the eBook, click https://www.go4as400.com/as400-ebook/Excel-VBA-to-AS400.aspx

    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



Copyright © www.go4as400.com, 2013-2023. Copyright notice   Terms of services   Privacy policy