VBA to RUMBA

[Wgimblet]

We are using RUMBA 2000 (CIS), I been looking for a way to move data from a spreadsheet into the application. I want the RUMBA macro to process then hopfully it can activate a VBA module that would parse the data then copy the information to buffer. This will allow the RUMBA macro to wait for the proper screens to paste the Data.

Does anyone know if this process is possible or is there a better way to create persistent variables for RUMBA macro automation?
and/or
Any information on how I could possible alter or manipulate the RUMBA macro through a VBA module?

or just any better idea all together?

 

[SkipVought]

Hi,

I'm guessing that RUMBA is a terminal emulator of some sort.

I have NO experience with RUMBA. NADA!! However, I regularly scrape data from an Attachmate!Extra emuator. I much prefer to run ALL my code from Excel VBA, as Excel VBA has much more flexibility.

One tip: Set a Reference to the RUMBA Object Library in the VB Editor in the Tools menu, if you plan to code in Excel VBA.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Wgimblet]

Thanks for the tip. I appreciate you taking the time to help us.

 

[kjv1611]

When you said RUMBA, I immediately thought of the little robot vacuums. However, I'm assuming you're not sending data to a vacuum cleaner via Excel VBA.