Excel Web Link

[jasonbecks]

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.

[Laterus]

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.

[Siddharth Rout]

Welcome to the forums jasonbecks.

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.

[jasonbecks]

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 r if i hyperlink that A1: i get back
http://movies.yahoo.com/
which I want in C1


for a range A1:A5000

[Siddharth Rout]

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

[jasonbecks]

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

[jasonbecks]

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