Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 190
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 239
Default 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
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 190
Default 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

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 239
Default 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
  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 239
Default 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.


  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 190
Default 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.

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
Double Click Event on Image Redan Excel Programming 0 March 27th 08 08:36 AM
Click to Add Image mtm4300 via OfficeKB.com Excel Programming 3 May 12th 07 11:53 PM
MouseMove & Click event over an image control furbiuzzu Excel Programming 1 June 30th 06 09:46 AM
Image Click Invokes Picture Toolbar Sunbank Excel Programming 0 January 16th 06 03:14 AM
Click on Image Control disables it Wexler Excel Programming 0 October 7th 03 05:35 PM


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

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"