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

On Sep 17, 6:32*am, geebee <geraldj...@hotmail.com(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

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 <geraldj...@hotmail.com(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
>

On Sep 17, 5:40*pm, geebee <geraldj...@hotmail.com(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 <geraldj...@hotmail.com(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

On Sep 17, 5:40*pm, geebee <geraldj...@hotmail.com(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 <geraldj...@hotmail.com(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.

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 <geraldj...@hotmail.com(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 <geraldj...@hotmail.com(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.
>