View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kremti Kremti is offline
external usenet poster
 
Posts: 5
Default 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