Can someone help to correct my vba. Error code 91 is appearing "object variable not set", but i am unsure of how to correct it. please help!!!
Please Login or Register to view this content.
Can someone help to correct my vba. Error code 91 is appearing "object variable not set", but i am unsure of how to correct it. please help!!!
Please Login or Register to view this content.
Last edited by chrishtina; 03-05-2015 at 04:20 PM.
Chris,
Please wrap your code with code tags as per forum's rule. Please read forum's rule.
Since the URL requires log-in details, I would not be able to help you further should you get another error.
Please Login or Register to view this content.
Thanks for your help, but now I'm getting error code 424 for some reason it won't press the login button.
Chris,
As I pointed out, it is difficult to see the source code if the address requires log-in details.
This line is definitely wrong
You need to put in the actual URLPlease Login or Register to view this content.
Sorry, I've included the address
ThanksPlease Login or Register to view this content.
I had similar code, but it might not work, but try it and see where do you get the error? Which line of the code?
Please Login or Register to view this content.
The error code doesn't appear until after the macro has finished running. Also, the submit button does not work. Could the error code have something to do with that?
The code is not supposed to do anything, but to open the site. How do you know the submit button does not work?
Where is the rest of the code?
Oh, I thought that the vba would direct me into the login afterwards. Do you have any similar codes to submit the login?
The simple answer is no. Your request requires 2 hurdles to jump on. First is to log-in to the site, and second is assuming that you are in, what information do you want to extract? I suspect you are new to web scrapping. I love to help you, but I am unable to test the code as it requires for me to log-in to the site.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks