VBA & Rumba

[ptw78]

Is it possible to write vba in an access(or excel file) to or from Rumba? Or is there a forum for this? I couldn't find one. thx

 

[SkipVought]

Hi,

Do you have a Rumba ODBC driver in your Data Sources?

If so, just link to the db and query, either from Access or Excel.

Skip,

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

 

[vbajock]

I used it years ago to access AS400 data, if that's what you are trying to do, I did it all the time. I have no idea what it is like nowadays, but back in the 90's you had to declare the AS400 libs in your module header and then use their VBA procedure templates to manipulate the data.

 

[ptw78]

This would be in excel. Basically i have a list of account numbers in excel, i want to plug that into rumba pull up the info for the acct and extract some data from rumba back to the excel list i have