tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,210
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi everyone,
OK I've got a big challenge for you all now,
I have a list of websites in column A of a spreadsheet, the number of website will vary as I have lot of sheets to go through, however what I want to do is open each site to see if its the type of website I'm looking for and put a yes or no next to each site.
so I'm looking for a macro that can start at A2 open up the web address in A2, then ask me "is this what you are looking for? I answer yes or no and the answer gets put into the excel document in column B next to the website (B2), we then move on to cell A3 and do the same thing and carry on until I've done all web sites in my list.
Does anyone know if this would be possible? if so,
how I could do it?
I'm on office 2013 and in have internet explorer and chrome loaded if that helps.
I know this might be to big a question for someone to answer on here but I was hopping maybe somebody would know how to do it?
here is a snippet of the websites if you need to test anything:
[TABLE="width: 656"]
<COLGROUP><COL style="WIDTH: 656pt; mso-width-source: userset; mso-width-alt: 32000" width=875><TBODY>[TR]
[TD="class: xl64, width: 875, bgcolor: transparent"]http://www.alcscapital.com/[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]http://www.vanessapollock.com/[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]http://www.propertyexhibit.com/[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]http://www.bergenhomeinfo.com/[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]http://www.azteccontainer.com/[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]http://www.islandappraisal.com/[/TD]
[/TR]
</TBODY>[/TABLE]
I could really do with help on this?
Thanks
Tony
OK I've got a big challenge for you all now,
I have a list of websites in column A of a spreadsheet, the number of website will vary as I have lot of sheets to go through, however what I want to do is open each site to see if its the type of website I'm looking for and put a yes or no next to each site.
so I'm looking for a macro that can start at A2 open up the web address in A2, then ask me "is this what you are looking for? I answer yes or no and the answer gets put into the excel document in column B next to the website (B2), we then move on to cell A3 and do the same thing and carry on until I've done all web sites in my list.
Does anyone know if this would be possible? if so,
how I could do it?
I'm on office 2013 and in have internet explorer and chrome loaded if that helps.
I know this might be to big a question for someone to answer on here but I was hopping maybe somebody would know how to do it?
here is a snippet of the websites if you need to test anything:
[TABLE="width: 656"]
<COLGROUP><COL style="WIDTH: 656pt; mso-width-source: userset; mso-width-alt: 32000" width=875><TBODY>[TR]
[TD="class: xl64, width: 875, bgcolor: transparent"]http://www.alcscapital.com/[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]http://www.vanessapollock.com/[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]http://www.propertyexhibit.com/[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]http://www.bergenhomeinfo.com/[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]http://www.azteccontainer.com/[/TD]
[/TR]
[TR]
[TD="class: xl64, bgcolor: transparent"]http://www.islandappraisal.com/[/TD]
[/TR]
</TBODY>[/TABLE]
I could really do with help on this?
Thanks
Tony