Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Double Click Event on Image | Excel Programming | |||
Click to Add Image | Excel Programming | |||
MouseMove & Click event over an image control | Excel Programming | |||
Image Click Invokes Picture Toolbar | Excel Programming | |||
Click on Image Control disables it | Excel Programming |