Skip to main content

Hi, 

I need help to create a Macro/script to connect from Microsoft Excel to Rumba, My Rumba version is 9.4.0 SP0 Patch0. Could you please share any document that have samples of macro from MS excel to navigate to Rumba and get the data from Rumba back to Excel?

Thanks.


#Rumba

Hi, 

I need help to create a Macro/script to connect from Microsoft Excel to Rumba, My Rumba version is 9.4.0 SP0 Patch0. Could you please share any document that have samples of macro from MS excel to navigate to Rumba and get the data from Rumba back to Excel?

Thanks.


#Rumba

Hi, there a a lot of samples and explanation in the Rumba Forum.
If you search for "EXCEL" in the Rumba Forum you should get want you need.

Below links should get you a good start.

How to automate rumba through Excel VBA
https://community.rocketsoftware.com/discussion/how-to-automate-rumba-through-excel-vba#bm928ba548-5cc4-47b6-841a-2775de48a1c5

How to paste data excel to rumba from a particular excel cell?
https://community.rocketsoftware.com/discussion/how-to-paste-data-excel-to-rumba-from-a-particular-excel-cell#bm1834b67f-ca88-4f9d-83fe-a1055492eece

Execute VBA command EXCEL in RUMBA
https://community.rocketsoftware.com/discussion/execute-vba-command-excel-in-rumba#bm61bc362e-810e-4d63-beb3-0485ccf83c69

Rumba Script Engine Syntax Language
https://community.rocketsoftware.com/discussion/rumba-script-engine-syntax-language#bm97af76bc-a0a1-479e-bdea-b35894b0ee32

cheers
andree


Hi, there a a lot of samples and explanation in the Rumba Forum.
If you search for "EXCEL" in the Rumba Forum you should get want you need.

Below links should get you a good start.

How to automate rumba through Excel VBA
https://community.rocketsoftware.com/discussion/how-to-automate-rumba-through-excel-vba#bm928ba548-5cc4-47b6-841a-2775de48a1c5

How to paste data excel to rumba from a particular excel cell?
https://community.rocketsoftware.com/discussion/how-to-paste-data-excel-to-rumba-from-a-particular-excel-cell#bm1834b67f-ca88-4f9d-83fe-a1055492eece

Execute VBA command EXCEL in RUMBA
https://community.rocketsoftware.com/discussion/execute-vba-command-excel-in-rumba#bm61bc362e-810e-4d63-beb3-0485ccf83c69

Rumba Script Engine Syntax Language
https://community.rocketsoftware.com/discussion/rumba-script-engine-syntax-language#bm97af76bc-a0a1-479e-bdea-b35894b0ee32

cheers
andree

Hi Andree, Thanks for the reply.

was going through the community rumba forum as suggested and came across "Map excel and rumba - Rumba - Forum - Rumba (microfocus.com)" here you have attached a link (https://dl.dropboxusercontent.com/u/47621867/RumbaOXSample%20.zip)  for some sample I am unable to open, can you paste it in here. Appreciate you help.  


Hi Andree, Thanks for the reply.

was going through the community rumba forum as suggested and came across "Map excel and rumba - Rumba - Forum - Rumba (microfocus.com)" here you have attached a link (https://dl.dropboxusercontent.com/u/47621867/RumbaOXSample%20.zip)  for some sample I am unable to open, can you paste it in here. Appreciate you help.  

Hi Mahesh,
please find below the sample mentioned in your post.

[quote userid="101457" url="~/cobol/rumba/f/forumid-12/513021/connecting-macro-script-from-ms-excel-to-rumba/1896347#1896347"]"Map excel and rumba - Rumba - Forum - Rumba[/quote]

Excel - Rumba OCX Sample

Note  the Rumba OCX example works with 32-bit Excel. If you plan to use 64bit Excel you would need to update to Rumba 10.1 SP1.

cheers

andree