Question Locked

automated pasting of webpages in excel

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

1 reply

This discussion is closed to new replies.