automated pasting of webpages in excel

By harshamutu ·
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

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums