01-29-2008, 06:07 PM
Hi to all,
I have an excel sheet where i have 3 columns: artist name, name of a song, and empty column to paste a url. Now what i`d like my macro to do is to copy first and second colums and paste it into search engine at http://www.youtube.com with some predefined string - "addon". Then it press search and get the first result from search (some video) and gets this video`s url (like e.x http://www.youtube.com/watch?v=rVOVdB-u9I4) and paste it into my excel sheet in 3rd column. Then repeat it like 8000 times
Worst thing is i have to do it in 2 versions. One automatic, and one semiautomatic. The automatic should work as one i discribed. Semi automatic is similar but needs a user reaction so user can choose from first four search results to be pasted in my sheet/url column.
Do you guys have any idea hot to do it? It`d save me a lot of time
Best,
I have an excel sheet where i have 3 columns: artist name, name of a song, and empty column to paste a url. Now what i`d like my macro to do is to copy first and second colums and paste it into search engine at http://www.youtube.com with some predefined string - "addon". Then it press search and get the first result from search (some video) and gets this video`s url (like e.x http://www.youtube.com/watch?v=rVOVdB-u9I4) and paste it into my excel sheet in 3rd column. Then repeat it like 8000 times
Worst thing is i have to do it in 2 versions. One automatic, and one semiautomatic. The automatic should work as one i discribed. Semi automatic is similar but needs a user reaction so user can choose from first four search results to be pasted in my sheet/url column.
Do you guys have any idea hot to do it? It`d save me a lot of time
Best,