Create a macro in .rmc file

Here is a method of reading from and writing to Excel from a Rumba script.

Sub Main

   Dim myExcel as Object    

   MyExcelDoc$ = "C:\\temp\\test.xlsx"

   Set MyExcel = CreateObject("Excel.Application")

   If (MyExcel is Nothing) Then

       Beep

       Msgbox "Could not create the Excel Application object."

   End If

   MyExcel.Workbooks.Open(MyExcelDoc$)

   'Read Excel Cells

   Msg$ = MyExcel.Cells(1, 1).Value  & ", " & MyExcel.Cells(1, 2).Value  & Chr$(13) & Chr$ (10)

   Msg$ = Msg$ & .Cells(2, 1).Value  & ", " & MyExcel.Cells(2, 2).Value  & Chr$(13) & Chr$ (10)

   Msg$ = Msg$ & .Cells(3, 1).Value  & ", " & MyExcel.Cells(3, 2).Value  & Chr$(13) & Chr$ (10)

   Msgbox Msg$    

   ';Update Excel cells        

   MyExcel.Cells(1, 1).Value = "Hello"

   MyExcel.Cells(1, 2).Value = 5

   MyExcel.Cells(2, 1).Value = "World"

   MyExcel.Cells(2, 2).Value = 6

   MyExcel.Cells(3, 1).Value = "!!!"

   MyExcel.Cells(3, 2).Value = 7

   Msg$ = MyExcel.Cells(1, 1).Value  & ", " & MyExcel.Cells(1, 2).Value  & Chr$(13) & Chr$ (10)

   Msg$ = Msg$ & MyExcel.Cells(2, 1).Value  & ", " & MyExcel.Cells(2, 2).Value  & Chr$(13) & Chr$ (10)

   Msg$ = Msg$ & MyExcel.Cells(3, 1).Value  & ", " & MyExcel.Cells(3, 2).Value  & Chr$(13) & Chr$ (10)

   Msgbox Msg$    

     MyExcel.Visible = True

   'MyExcel.Save

   Set MyExcel = Nothing

End Sub

'Note: The script above assumes c:\\temp\\test.xlsx exists

Can we do the other way around also? Copying data from Excel to Rumba ?

Hi Extremis,

the ActiveX approach above uses this approach, i.e. the conversation between Excel and the host is being driven from Excel VBA. One embeds a Rumba ActiveX Terminal on an Excel VBA Form and drives the terminal session from Excel VBA.

If you need Excel to talk to a Rumba session which is open in the Rumba Workspace, then we recommend you use a Rumba Script.

It is possible to use HLLAPI calls in Excel VBA to drive the conversation, but we do not recommend using HLLAPI in "new" solutions.

Tom

Is the language in Rumba the same as in Excel, meaning can I program in VBA in Rumba ?

Hi Extremis,

Rumba script is not MS VBA but it is quite similar in syntax.

There is extensive help in the script editor for the various functions methods and properties provided by the engines built-in libraries.

A good way to figure out how to automate the navigation is to record some navigation and then examine the code which is generated.

Remember you need to learn to walk before you can run, so try to separate your end goal into multiple achievable mini tasks, e.g Reading data from Excel cells, writing data to Excel cells, reading data from a Rumba host screen, writing to a Rumba host screen, navigating between host screens, launching Excel or Rumba or both, configuring the Rumba connection setting, etc.

Tom

Do you have a bunch of scripts on your computer that you could send me ? It would be awesome! I would then study the programming language. Thanks.

Hi extremis,

take a look into the Rumba installation folder under System\\ScriptEngine\\Scripts. Here you will find some useful scripts that should help. There are  two  3270 to Excel scripts.

cheers

/a

Hi,

My company wiped it out -_-.....

Would it be possible to send me the scripts via me email?

extremis_@hotmail.com

Also, can you send me the script that show you how to build a connection with Rumba to Excel ?

Thanks.