Run scrape session from inside MS Access db via VBA
Hi -
Could somebody give me a steer please on how to call a scraping session externally from inside Microsoft Access db using Visual Basic for Applications?
I have got as far as the following:-
Sub Test_remote_scraping_session()
Dim objRemoteScrapingSession As RemoteScrapingSession
Set objRemoteScrapingSession = ????
objRemoteScrapingSession.Initialize ("My_scraping_session")
objRemoteScrapingSession.Scrape
End Sub
I think the last 2 lines are OK, but I'm not sure if I need to declare a 'RemoteScrapingSession' object first, and, if I do, what I 'set' it to if I do.
If anybody could give me a brief steer on this problem, that would be much appreciated.
Many thanks,
pete
Run scrape session from inside MS Access db via VBA
Pete,
This is not my place of expertise but have you looked over our documentation on invoking screen-scraper via COM?
http://www.screen-scraper.com/support/docs/invoking_screenscraper_from_com.php
Let us know if it this helps.
-Scott
Run scrape session from inside MS Access db via VBA
re: the last post, I forgot to add I do have the SS Server running, and 'Screenscraper' is showing up in my list of References inside my Access/VB programming environment (pointing to the correct COM DLL) and I do have it selected!
Run scrape session from inside MS Access db via VBA
I also need help getting the VB object set. I got the majority of the calls from the
http://community.screen-scraper.com/invoking_screen-scraper_from_a_COM-based_application link, but the first couple lines I'm mixing up also. I'm a java/C# developer and I just can't figure out how I need to initialize the RemoteScrapingSession object.
Private Sub Command11_Click()
??? Dim objRemoteScrapingSession As Object
??? Set objRemoteScrapingSession = remoteScrapingSession.Initialize("ecommit")
??? 'objRemoteScrapingSession = New remoteScrapingSession
Call objRemoteScrapingSession.Initialize("ecommit")
Call objRemoteScrapingSession.SetVariable("PATRON_COMBO", Me.PatronCoComboBox)
Call objRemoteScrapingSession.Scrape
objRemoteScrapingSession.Disconnect
End Sub