Excel VBA RemoteScraping Session
I am having difficulty with running a remote scraping session from Excel VBA - generates "Error 429 (ActiveX component can't create object)".
Dim objSession As Screenscraper.RemoteScrapingSession
If objSession Is Nothing Then Set objSession = New Screenscraper.RemoteScrapingSession
Please advise?
matekus
matekus,Have had a look at
matekus,
Have had a look at this KB?
http://support.microsoft.com/kb/260885
-Scott
Office 2007 - KB Does Not Apply
Scott,
Thanks for the prompt follow-up.
However, as I am using Office 2007, this KB does not apply.
matekus
What is the next line in your
What is the next line in your code when you're instantiating the object?
Try alternating between "localhost", "127.0.0.1", and the IP of the machine screen-scraper is running on.
RemoteScrapingSession("Shopping Site", "192.168.0.5", 8778 );Scott,The next lines are as
Scott,
The next lines are as follows:
Dim objSession As Screenscraper.RemoteScrapingSession
If objSession Is Nothing Then Set objSession = New Screenscraper.RemoteScrapingSession
Call objSession.Initialize("TestScraper")
Call objSession.Scrape
...
Note that the code fails on the "New" call and that TestScraper works as designed in the Screen-Scraper IDE.
matekus
matekus, I'm not a .Net
matekus,
I'm not a .Net programmer, so please excuse any obvious faux pas in my code.
Have you tried something like the following?
If objSession Is Nothing Then Set objSession = New Screenscraper.RemoteScrapingSession
Call objSession.Initialize("TestScraper","127.0.0.1",8778)
//or
// Call objSession.Initialize("TestScraper","YOUR_LOCAL_IP_ADDRESS",8778)
Call objSession.Scrape
I'm not certain that the way you are initializing the objSession object is allowed. Your approach differs from our sample code some.
Try specifying the host even if you are running screen-scraper on the same machine as your .Net app.
-Scott