Hey guys,
I'm working on my master thesis right now and I'm facing quite a complicated problem (at least for me). Maybe someone can help to solve it or least tell me if it is actually solvable. I haven't found anything comparable in the topics database here.
I have an Excel file with more than a thousand links to websites in one column. They always refer to kickstarter.com, could be for example this link:
kickstarter.com/projects/539752036/the-vault-music-studios?ref=nav_search
So, I'll explain to you what I manually would need to do now. I want to click each link in the Excel file, visit the website, check if there is a link somewhere (slight problem: there might be more than one link), click this/these link(s), and check if the/these link(s) is/are still active. Then I want to make a note into the Excel file, more precisely into the column next to the respective link, which says either "No link available on kickstarter.com" or "Link(s) available but the respective website(s) is/are inactive" or "Link(s) available and website(s) still active". It doesn't matter if one or more more than one link is still active, that would always be category 3. Well, actually I wouldn't write out the three options either, just assign 1,2, and 3 to them. But just so that you get the picture.
My question is now: Is it possible to automate that in Excel oder in any other (affordable) software? Stata for example would actually also work, I have a license for that. And if it is not possible, can I at least automate to click the respective link in the Excel file and then check on this website if there is an URL at all?
Thanks a lot in advance!
Cheers,
Jonas
I'm working on my master thesis right now and I'm facing quite a complicated problem (at least for me). Maybe someone can help to solve it or least tell me if it is actually solvable. I haven't found anything comparable in the topics database here.
I have an Excel file with more than a thousand links to websites in one column. They always refer to kickstarter.com, could be for example this link:
kickstarter.com/projects/539752036/the-vault-music-studios?ref=nav_search
So, I'll explain to you what I manually would need to do now. I want to click each link in the Excel file, visit the website, check if there is a link somewhere (slight problem: there might be more than one link), click this/these link(s), and check if the/these link(s) is/are still active. Then I want to make a note into the Excel file, more precisely into the column next to the respective link, which says either "No link available on kickstarter.com" or "Link(s) available but the respective website(s) is/are inactive" or "Link(s) available and website(s) still active". It doesn't matter if one or more more than one link is still active, that would always be category 3. Well, actually I wouldn't write out the three options either, just assign 1,2, and 3 to them. But just so that you get the picture.
My question is now: Is it possible to automate that in Excel oder in any other (affordable) software? Stata for example would actually also work, I have a license for that. And if it is not possible, can I at least automate to click the respective link in the Excel file and then check on this website if there is an URL at all?
Thanks a lot in advance!
Cheers,
Jonas