Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Have a Big Question
Hello everyone! I have somewhat of a difficult question that I hope
somebody can answer. Here's the problem I'm trying to design a vba that can take you to a web site and verify weather the site works and that there is also a certain keyword there also. (for example if I just clicked on http://www.now.com and I'm checking to see if the anchor text shoe is there by just clicking on that web address from the spreadsheet without using the find tool) Now I used the GoToHtml code and it worked it takes you to that website but that's it what I'm trying to do is to be able to select mulitple rows and check them all instead of just one. I've tried web queries but that doesn't work. So I'm asking is this possible to do in VBA and make it a macro or is there a different way to go about. Thanks to all who reads this and replies |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Have a Big Question
Hi, your problem can be addressed by, accessing the Internet Explorer object
and using its methods and properties within VBA. "Art Steele" wrote: Hello everyone! I have somewhat of a difficult question that I hope somebody can answer. Here's the problem I'm trying to design a vba that can take you to a web site and verify weather the site works and that there is also a certain keyword there also. (for example if I just clicked on http://www.now.com and I'm checking to see if the anchor text shoe is there by just clicking on that web address from the spreadsheet without using the find tool) Now I used the GoToHtml code and it worked it takes you to that website but that's it what I'm trying to do is to be able to select mulitple rows and check them all instead of just one. I've tried web queries but that doesn't work. So I'm asking is this possible to do in VBA and make it a macro or is there a different way to go about. Thanks to all who reads this and replies |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|