click image in web

[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

 

[Madiya]

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

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

Regards,
Madiya

 

[geebee]

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

 

[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 -

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

 

[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 -

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.

 

[geebee]

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