selecting a tab on a website

Jackblack1

Jackblack1

Active Member
Joined
Feb 10, 2004
Messages
266
Hi all

Sorry about the other thread....figure it had a relationship, but anywho, :oops:

I have worked a on the macro a little but still have problem trying to figure out how to make it work. I can log into a website using the username and password but now I get to the opening page. Starting from the opening page I need to tab over to a tab name reporting. If you were to use the tab button it would 7 tabs to get to the reporting, I tried Send Keys but they do not work, aslo I tried something from another post.

Sub test()
Set ie = CreateObject("InternetExplorer.application")
ie.Visible = True
ie.navigate ("https://www.example.com)<----- not real site
Do
If ie.readyState = 4 Then
ie.Visible = True
Exit Do
Else
DoEvents
End If
Loop

ie.document.forms(0).all("Username").Value = "mahonse"
ie.document.forms(0).all("Password").Value = "example"
ie.document.forms(0).submit
Application.Wait (Now + TimeValue("00:00:12"))

Set myTextField = .document.all.Item("Reporting")
ie.document.forms(0).submit

End Sub
 
Sort by date Sort by votes
Jim

This is going to be nigh on impossible to help with without knowing the URL.

What do you mean by a 'tab' on a webpage?
 
Upvote 0
HI Norie

The Url is posted below the problem is there is no way to access the page without having a keygen that produces a password every minute, I can't post a password on the forum because of the sensitivity of the information on the website.

The tabs are links to other pages I need to beable to click on the link the at the tab is assigned to.

Sub test()
Set ie = CreateObject("InternetExplorer.application")
ie.Visible = True
ie.navigate ("URL removed by admin upon request")
Do
If ie.readyState = 4 Then
ie.Visible = True
Exit Do
Else
DoEvents
End If
Loop

ie.document.forms(0).all("Username").Value = "example"
ie.document.forms(0).all("Password").Value = "example"
ie.document.forms(0).submit

Application.Wait (Now + TimeValue("00:00:12"))
Set myTextField = .document.all.Item("Reporting")
ie.document.forms(0).submit

End Sub
 
Upvote 0
Jim

So you can get past the initial login OK?
 
Upvote 0
yes I can Norie, I can log in perfectly, but it when I get in the website that I need to figure out how to get to the link and select it. Pretty much from there on everything is selecting links and I can custom it.

But I still to create the pop up input box that I can enter the password into instead of changing the macro. This is my first time doing all of this so I'm sorry if I'm making it difficult. 8-)
 
Upvote 0
Jim

I think you'll have to work this one on your own.:)

The only way I've been able to help people with this sort of thing in the past is if I've been able to access the webpage.

That's kinda essential to find out what the elements etc on it are.

Also I'm a little uneasy about doing this for a secure site.

I'm not quite sure what the site actually is but I do know Goldman Sachs are rather large bank/investment institute.:)
 
Upvote 0
I totally understand, I feel a little uneasy posting anything on the forum about this information too. I will try to find other ways to do this or I will try to find a website similar to see if we can do it. I will keep you posted, is there a way to delete this post so that the web address is deleted from the forum?
 
Upvote 0
Jim

Just goto the post with the address and edit it to remove the address.

If you can't do that, I think there might be some restrictions on when you can edit a post, then contact the moderators.

If you can find a similar non-secure site perhaps we could help further?
 
Upvote 0
Great thanks Von,


To continue with my original question,

I went over some websites last night to find tabs that I am looking for to get code for. So let me explain, I am automating a process through excel. I have figured out the code behind to log in to a particular website. Now, on the website for example www.fidelity.com (generic site) there are tabs on the page that are attached to links, the research tab would take you to research page. What I am trying to do is figure out how to code the selection of the link or tab, and submitting it. I realize it is possible to create send keys but I never have uses them before can someone help me here.

Thanks!
 
Upvote 0
Jim

Clicking on any of the items in that menu/toolbar brings up another (sub?) menu/toolbar.
 
Upvote 0
You must log in or register to reply here.

Similar threads

L
  • Question Question
VB Error 91
Replies
2
Views
137
Peter_SSs
Peter_SSs
O
  • Question Question
Another problem reading HTML-page
Replies
2
Views
535
Oldfox
O
O
  • Question Question
Reading html file from local hard drive
Replies
1
Views
393
Ruddles
Ruddles
F
  • Solved
Webscraping a site with no element ids and returning data
Replies
6
Views
2K
fizzydrink
F
C
  • Question Question
VBA to wait until IE webpage finishes loading before running the next step
Replies
3
Views
6K
cdalgorta
C

Forum statistics

Threads
1,226,838
Messages
6,193,260
Members
453,786
Latest member
ALMALV

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top