Excel Web Link

Please can anyone help, I need to do the following:

Run a macro on large list of URL's on excel to copy them from excel and paste it into IExplorer and then copy the resultant URL back into the list.

That I am aware you can't quite do it directly. Excel does have a feature to import from the web under the data tab.

If it is something you want to automate, there is an addon to firefox/IE that can do it, I do something similar in my work. The addon is called iMacros and it can extract data from a web page to a text file, and also fill forms from a text file. Excel can also communicate with the text file. There's a paid version of iMacros that can do it more easily and more directly, but using a text file as an intermediary between the programs allows you to do it with the free version.

Welcome to the forums jasonbecks. :wave:

Yes it is possible to achieve what you want from VBA using the webbrowser control.

Place a webbrowser control in a userform. Then use .Navigate <url> method to navigate to that link. Once webbrowser loads, simply retrieve the url from the webbrowser Address bar.

Give it a try and if you get stuck then simply post the code that you tried and the error that you are getting. We will then take it from there.

Thanks for the help, but at moment i am really not getting too far.

possibly u can provide more of a walthru?

i have in cell A1
http://www.yahoo.com/movies
if i copy that cell to IE URL :or if i hyperlink that A1: i get back
http://movies.yahoo.com/
which I want in C1


for a range A1:A5000

Do you know how to create a userform and place a webbrowser on it?

i got that far. but really no idea how to integrate it all

I have built a userform with the webbrowser but not sure of coding to integrate it use the webrbowser