For years people have had macros running on ExCel VBA that connect to the old green screen and do screen scraping style macro processing. Sometimes reading data from the IBM i and writing to the spreadsheet, and sometimes taking input data froma spreadsheet and making updates to suit on the IBM i.
Existing stuff is done via this interface http://www-01.ibm.com/support/knowle...t_access08.htm
That's all understood and working funky like, then along comes IBM i Client Access Solutions, the new thing running java. While there are macros under an XML format that can be recorded etc, I am struggling to find any documentation on integrating these with VBA for Excel.
Anyone else looked at this?
GC
Existing stuff is done via this interface http://www-01.ibm.com/support/knowle...t_access08.htm
That's all understood and working funky like, then along comes IBM i Client Access Solutions, the new thing running java. While there are macros under an XML format that can be recorded etc, I am struggling to find any documentation on integrating these with VBA for Excel.
Anyone else looked at this?
GC
Comment