Load Excel VBA Macros to work with IBM Host on Demand

[Kristofferdk]

Hi Exp

i would like to Load Excel VBA Macros, in ordre for them to work with IBM Host on Demand. I work white Excel 2007; and need to transfer data in to Host on Demand. Is the a, standard way to do so ?

Ore do some of you know of Macros that all read exist ?

[jetted]

Are you looking for something to hook you up with the mainframe?

[Kristofferdk]

hey

sorry the late reply.

To specify my problem I want to transfer data located in an Excel sheet to IBM’s Host on Demand and update the screen to save the data there. I’m obviously able to extract the data into a variable by using VBA, but my problem is to ‘tell’ HoD to paste certain information into a specific place and update the screen – and by doing so be able to update the data automatically by using a loop or the like. How do I do this? Do I need a reference in VBE? Does anyone have an example of some code dealing with this problem?

Kind regards