I shall be thankful if someone could let me have a VB code that gets Excel to follow the hyperlinks pasted in one column to copy and paste the linked web pages,one at a time on a second worksheet automatically.
(I hope to process the web contents pasted one below the other on the second sheet later to create a database.)
I would want the the browser window to be closed just after each web page is copied to avoid memory issues after copying the content window for pasting.
I am ignorant of VB and assistance in this difficulty I have at the moment is very much appreciated.
Thanks and Regards
