Prev: Sumproduct error
Next: Another Easy Question
From: אלירם on 26 Mar 2010 08:42
Hello,
I have a spreadsheet with 3,000 URL addresses.
I'd like to create a macro which scan each line, and show me if the URL
exists or not.

For instance:

Column A Column B
http://www.google.com | valid
http://www.jkgjkjkdjsl.net | invalid
http://ww.life.com/files/heart.pdf | invalid


Thanks
From: אלירם on 26 Mar 2010 09:11
canceled...

Tim is helping me here:
http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public.excel.programming&mid=2a68c671-8660-4cb7-b4a3-ea12070d6fd3

"אלירם" wrote:

> Hello,
> I have a spreadsheet with 3,000 URL addresses.
> I'd like to create a macro which scan each line, and show me if the URL
> exists or not.
>
> For instance:
>
> Column A Column B
> http://www.google.com | valid
> http://www.jkgjkjkdjsl.net | invalid
> http://ww.life.com/files/heart.pdf | invalid
>
>
> Thanks
 | 
Pages: 1
Prev: Sumproduct error
Next: Another Easy Question