Hey all,
I'm working on a macro that can go to a webpage and login in (got that). But then I need it to select the name of a site on a dropdown box and hit submit. Then I need it to copy an entire table to a cell in my spreadsheet (it will always be 2 columns wide).
Any help would be much appreciated!
Here is the code for the drop down menu:
And here is the code for the table that it prints out:
Please Login or Register to view this content.
Please Login or Register to view this content.
Can you post the VBA code?
If posting code please use code tags, see here.
Not much so far, I'm stuck on this point...
Please Login or Register to view this content.
EDIT:
Might be important to mention that the table output one the button is pressed will always be a different size
Last edited by Jman12; 12-14-2012 at 09:33 PM. Reason: Forgot stuff
Kind of hard to help without a valid URL.
A couple of things about the code though.
You only need one With.
There is no form1, but document does have a forms collection and you can refer to the first form using forms(0).
I would but it is a company website, so its confidential blah blah blahOriginally Posted by Norie
Kind of hard to help without a valid URL.
How do I refer to the first form and then alter the value of the first option? Sorry I don't know much about forms at all
Last edited by Jman12; 12-14-2012 at 09:37 PM.
I already suggested how to refer to the first form.
To refer to the dropdown you could use the form's elements collection.
Perhaps something like this.
That code is not guaranteed to work at all - the cbo lines I'm a bit unsure about.Please Login or Register to view this content.
So far your always right. Code works great until you reach the line
Anyone know how to reference the portion of the frame?Please Login or Register to view this content.
What do you mean the 'portion of the frame'?
Sorry, don't know enough to not even sound stupid >.>
I mean how to change that particular combobox. frm.Items("site") came out with an error:
"Run-time error '438': Object doesn't support this property or method"
That was the one line I was pretty sure wasn't right.
You can try this instead,
or thisPlease Login or Register to view this content.
Not 100% sure about those either.Please Login or Register to view this content.
Thanks so much for your help so far!!
This works up until submitting now, it just refreshes the page?
Please Login or Register to view this content.
Submit doesn't always work.
Try clicking the button.
Please Login or Register to view this content.
That now pops the same 438 error. I made sure to Dim As Object. Any other suggestions for me?Please Login or Register to view this content.
This is the sort of thing made harder by not having the URL.
Here's something else to try but I'm not too confident about it, as it's similar to getElementsByClassName which should work.
PS I've just created a small HTML file with the code I posted.Please Login or Register to view this content.
When I run the code I posted in post #12 I get no errors.
First time back since the weekend. Thank you so much!!! It works great now, absolutely perfect so far! One last step...
Need it to copy the table that results, which is encoded as:
Any wonderful tips on that Norie?Please Login or Register to view this content.
PS. IDK how to say that you enough, even this part so far saves me like 30m a day so far.
Tried very hard to get any farther. The best I can do is this:
So far all this gets me is a Value of "[object]", and I don't know how to make it anything else. I need it to copy/paste the entire 2 tables that result from this page. One is called "statusDiv", the other is "displayDiv"Please Login or Register to view this content.
Is this all the code there is?
DIV elements are used as containers so I would have expected there to be code for what's contain within the DIVs.Please Login or Register to view this content.
Yes this is it
I'll paste nearly the entire source code:
PS. This is after I select the site and have all the data I want copied visible.Please Login or Register to view this content.
Last edited by Jman12; 12-20-2012 at 09:50 PM. Reason: forgot explination
How are you viewing/copying the source code?
I was just right clicking and viewing source... But going into Developer Tools in IE I get more data... sorry about that....
Here's as much data as I can pull:
Also copying the rows instead of columns would work fine, columns would just be easier for me. But either way ^-^Please Login or Register to view this content.
It's probably easier to get the entire table rather than specific columns.
I've got some code for that, I'll try and post it tomorrow.
Thank you so much!
Don't mean to bug you Norie I thank you for your help so far, was just wondering if youve had time to dig up this code in between the holidays? TY!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks