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%3DAdultF%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
Bookmarks