ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   click image in web (https://www.excelbanter.com/excel-programming/417176-click-image-web.html)

geebee

click image in web
 
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

click image in web
 
On Sep 17, 6:32*am, geebee (noSPAMs) wrote:
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

click image in web
 
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" wrote:

On Sep 17, 6:32 am, geebee (noSPAMs) wrote:
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


Madiya

click image in web
 
On Sep 17, 5:40*pm, geebee (noSPAMs) wrote:
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" wrote:
On Sep 17, 6:32 am, geebee (noSPAMs) wrote:
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- Hide quoted text -


- 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

click image in web
 
On Sep 17, 5:40*pm, geebee (noSPAMs) wrote:
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" wrote:
On Sep 17, 6:32 am, geebee (noSPAMs) wrote:
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- Hide quoted text -


- 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

click image in web
 
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


"Madiya" wrote:

On Sep 17, 5:40 pm, geebee (noSPAMs) wrote:
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" wrote:
On Sep 17, 6:32 am, geebee (noSPAMs) wrote:
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- Hide quoted text -


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



All times are GMT +1. The time now is 05:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com