Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Click on cell link to another worksheet in same workbook | Excel Discussion (Misc queries) | |||
Click on a word and have it link to another page | Excel Discussion (Misc queries) | |||
How to enforce to be opened by specified program after click the file link | Links and Linking in Excel | |||
Excel: How do I set up a cell to click it to link a database? | Excel Discussion (Misc queries) | |||
Link - deactivate being sent to source when click on linked cell? | Excel Worksheet Functions |