Quote Originally Posted by Kenneth Hobs View Post
Telling us how you want the problem solved, can lead to no solution. Well defining a problem can help us not take a wrong or slow solution's approach.

You must be new to forums. Click the Go Advanced button in the bottom right of a reply. You can then click the paperclip icon to browse and select a file to attach. Most forums work this way with a few exceptions.

When you ran that other code to select and copy the selections to the clipboard, did the paste to an Excel sheet produce what you wanted?

IF you don't want to post the short workbook as I requested, then post the URL so we can test it. What I can get from that is is it a file you want or scrub the URL site. Some URLs point just to files for download.

Doing a 1,000 URLs the ie object method is bound to be extremely slow and prone to problems.

The thread that you referenced does not exist and a search at ozgrid did not find it. After your 5th post I believe, you can simply paste the URL to create the hyperlink.