Help with screen scraping

[erindyl]

Hi, I’m trying to set access up so that I can screen scrape from a telnet session (RUMBA) and I am getting the following error message.
Runtime Error ‘424’
Object Required

I’m really not an expert at writing in VB or VBA, but I do understand the basics. Heres an example of the code I wrote :

Function SreenScrape()

Dim Sess0 As Object
Dim myvalue As Variant

Set Sess0 = GetObject("C:\Program Files…program.wdm")

myvalue = Sess0.Screen.select(5, 10, 5, 20)

End Function

Am I doing something shockingly wrong, or is this a minor mistake?

Jarrod

 

[masif]

Hi Erindly.

I have find your post that you were trying to do screen scrapping in 2001 around 11 years ago. I am stuck at same point. I am trying to do screen scrapping using VBA (MS ACCESS) and Rumba. Can you please help me. I have spend lots of time on internet and tried different development techniques but not able to figure out. I feel like helpless can you please help me. thanks

 

[ganeshkumars82]

Hi Erindly.

I have find your post that you were trying to do screen scrapping in 2001 around 11 years ago. I am stuck at same point. I am trying to do screen scrapping using VBA (MS ACCESS) and Rumba. Can you please help me. I have spend lots of time on internet and tried different development techniques but not able to figure out. I feel like helpless can you please help me. thanks

Hi,

I am also struggling to scrap the mainframe screen using VBA and MS Access. Please if you have solution, please help me on the same.

Thanks in advance

Regards,
Ganesh

 

[masif]

Hi Ganesh.

Tell me in detail. What exactly you are after. May be I can help you with that.

thanks

 

[ganeshkumars82]

Hi masif,

Thanks for your reply.
The workflow is as follows and I need the automation for the same in MS Access.
I need the code only to pass the paramenter from MS Access to Mainframe screen then copy the complete screen from Mainframe and paste them in one text box.

Actually I am am using CITRIX environment to open the TN3270 Plus to access the rumba screen. Once it opens, I want to pass the item from MS-Access to followin parameters to Mainframe screen.
1) "gateway" from MS Access Table. (wait until it go to next mainframe screen)
2) "username","password" (wait until it goes to next mainframe screen)
3) Select the complete screen Ctrl + A and C
I have the code to paster rest of all the activity.

Thanks in advance