click image in web

  • Thread starter Thread starter geebee
  • Start date Start date
G

geebee

hi,

i already have vba to navigate to a web page. i just need some code to
click on an image in the web page. i checked thhe source of the html, and it
looks like:

<td><table id="Menu_4_i0" onmouseout="Menu.Out(this);" width="100%"
rmCss="MenuItem" rmLab="View Reports" class="MenuItem"
onmouseover="Menu.Over(this);" cellspacing="0" rmCssOver="MenuItemOver"
cellpadding="0">
<tr onclick="goTo('/Reports/ReportList.asp', '')">
<td width="26"><img src="/Shared/Images/Icons/smallIcon_View.gif"></td>
<td nowrap class="MenuItem">View Reports</td>


so i am trying to figure out how i can use vba to click on the view reports
image or item.

thanks in advance,
geebee
 
hi,

i already have vba to navigate to a web page.  i just need some code to
click on an image in the web page.  i checked thhe source of the html, and it
looks like:

<td><table id="Menu_4_i0" onmouseout="Menu.Out(this);" width="100%"
rmCss="MenuItem" rmLab="View Reports" class="MenuItem"
onmouseover="Menu.Over(this);" cellspacing="0" rmCssOver="MenuItemOver"
cellpadding="0">
                        <tr onclick="goTo('/Reports/ReportList.asp', '')">
                                <td width="26"><img src="/Shared/Images/Icons/smallIcon_View.gif"></td>
                                <td nowrap class="MenuItem">View Reports</td>

so i am trying to figure out how i can use vba to click on the view reports
image or item.

thanks in advance,
geebee
Click to expand...

You can use navigate with path in following line
<tr onclick="goTo('/Reports/ReportList.asp', '')">
along with parent url.

Regards,
Madiya
 
hi,

i tried:
...
myURL2 = "https://site.com/Reports/ReportList.asp"
myIE.navigate myURL2

but it doesnt work.  just goes back to the login screen with username and
password cleared out.

any ideas?  is this what you meant?

thanks in advance,
geebee







- Show quoted text -
Click to expand...

Check html source on login screen.
with help of elements on login screen, enter username and password and
then try to go to myURL2

Regards,
madiya
 
hi,

i tried:
...
myURL2 = "https://site.com/Reports/ReportList.asp"
myIE.navigate myURL2

but it doesnt work.  just goes back to the login screen with username and
password cleared out.

any ideas?  is this what you meant?

thanks in advance,
geebee







- Show quoted text -
Click to expand...

Also try to paste your url in browser and see if it works.
If you can not locate login elements in html source, post the source
here.
Regards,
Madiya.
 
hi,

ok i have another idea... i have the following:

Function IsValidUrl(ByVal URL As String) As Boolean
IsValidUrl = URL Like "(http|ftp|https)://([\w-]+\.)+(/[\w- ./?%&=]*)?"
End Function


Sub YY()
MsgBox IsValidUrl("http://www.microsoft.com/en/us/default.aspx")
End Sub

but not sure how to get it to work... the msgbox is returning false... any
ideas?

thanks in advance,
geebee
 
Back
Top