ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   OK, so I can't click on a link in IE (https://www.excelbanter.com/excel-programming/327003-ok-so-i-cant-click-link-ie.html)

Kremti

OK, so I can't click on a link in IE
 
After doing all of opening IE browser window and all that (referencing
Microsoft Internet Controls, Dim IEObj As SHDocVw.InternetExplorer and
all that is taken care of. I can open a browser and navigate to an
adress).

This doesn't work :p

Set ipf = IEObj.Document.all.Item("DTsort=STYLENAME")
ipf.Click

The relevant HTML code is (I think)

<a
href="javascript:sSort('STYLENAME','-POPULAR','DTsort=STYLENAME;
path=/sb/s.jsp','%2Fsb%2Fs.jsp%3F%26Brand%3Dadidas%26Dept%3 DAdultF%26Profile%3D2%26Req%3Dprof%26scrc%3D-1%26Page%3D1');"
class="sortbytext"Style Name</a

Trying to drive the browser from Excel and pick off some texts from the
website (Need to go through 700+ pages and I want to automate the
process...). Any idea what I'm doing wrong? I've got only a vague
idea of how to manipulate the IE object...

-K



All times are GMT +1. The time now is 06:51 AM.

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