Rumba Mainframe Excel/VBA Macro

[Sachin Shama]

Hi ,
I am trying to write a macro which takes the values from my excel sheet & put it into RUMBA mainframe & viceVersa.I have been successful to code the 'excel to Mainframe' copy functionality.However, I am facing issue when I copy text from mainframes to Excel. I have tried using CopyPSToString / CopyPS / CopyFieldToString functions but everytime the string is returned as blank..... I have read somewhere that I have to change default session settings to 'ATTRB' which can be done by using SetSessionParameters , However, I am not able to use it?
Can anybody please help on this?


Thanks,
Sachin

 

[Avanish13]

hi Sachin,

When i am using the code to connect rumba from excel using VBA by using the function WD_ConnectPS(100,"A") then this function always returns 1. for successful connection it has to be return 0.

please tell me where i wrong.

Thanks.

 

[gmkarun]

Hi Sachin,
I know it is old thread, but I have the same problem in connecting to Ruma WebToHost Pro client using Excel vba.
When I try to run your code from excel macro window, I am getting "Compile Error. Can't find project or library."

EHLAPI32.DLL Path: "C:\Program Files (x86)\NetManage\RUMBA\system\Ehlapi32.DLL"
OS: win 7
Rumba: WebToHost ProClient Version 5.3.1

It would help me a lot, if could send a sample code to connect rumba using excel and then entering values in to mainframe display and reading from it.

Thanks
Mahesh