Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 93
Default Webpage Navigation

I'm having difficulty navigating around within a webpage with my macro. I'm
trying to utilize:

With .Document.Forms(0)
.Item("Search").Click
End With

and it doesn't seem to be working. The .Item("Search").Click is where it
errors out.

With .Document.Forms(0)
.Item("UserName").Value = "Your UserName Here"
.Item("Password").Value = "Your Password Here"
.Item("Submit").Click
End With

I get the same issue with this....all works fine until the
..Item("Submit").Click It will enter my name and password, then bug out.
What am I doning wrong with the syntax?

Thanks!!!


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 72
Default Webpage Navigation

Change .item("submit").click to:

..Submit

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 93
Default Webpage Navigation

That worked great for the logon information page. However, if I'm doing just
regular run of the mill navigation throughout the webpage, what is the basic
code for that sort of thing. For example, how do I utilize a "Search"
button? Make sense?

Thanks in advance.

"Dave Miller" wrote:

Change .item("submit").click to:

..Submit


  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 72
Default Webpage Navigation

You would either need to identify the ID of the button and use:

..item("Button ID Here").click

Or you would have to loop through all the items in the document until
you reached the name of the item you want to click:

For i = 0 To .Items.Length - 1
With .Item(i)
If .Name = "Name of Button" Then
.Click
End If
End With
Next


This process is the same for any item in the document (textbox,
checkbox, ...)

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Navigation Ridhi Excel Worksheet Functions 1 June 3rd 08 06:00 PM
navigation Pam M Excel Discussion (Misc queries) 3 November 7th 07 09:47 PM
Navigation slavenp Excel Discussion (Misc queries) 3 August 15th 07 07:03 PM
Navigation dgragg Excel Worksheet Functions 1 April 5th 06 08:10 AM
Navigation help please Walt Campbell New Users to Excel 3 May 30th 05 08:52 PM


All times are GMT +1. The time now is 01:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"