VBA Query

[muddan madhu]

Hi,

I have data in 10 columns.

In a column I have data related to some codes take an example of
routing numbers.(ABA number)
Suppose user provided 10 routing number in a specified column A.

I need to validate,validate means I have to go specific web address
and enter the routing number
provided by the user and I need to check is it a valid or not.

To minimize the time any macro can be assigned to validate whether
the
mentioned routing number is valid or not ? i.e., if I run the macro
copy the routing number
go to web address and check whether it is valid or not.

if its correct as per the web site here in excel file color it the
cell with some color.

Is this possible ?

 

[Don Guillett]

More detail along with url, etc

 

[muddan madhu]

suppose in A2 I have routing number 021000021, similarly there are 100
routing numbers in A3 to A100

I will check those routing number in http://www.fedwiredirectory.frb.org/search.cfm
and check whether the bank name is appearing or not.

how do it in excel macro ?

 

[Don Guillett]

I couldn't find a way to check each url except to download this and check
against that using a FIND macro
https://www.fededirectory.frb.org/fpddir.txt


--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)
suppose in A2 I have routing number 021000021, similarly there are 100
routing numbers in A3 to A100

I will check those routing number in
http://www.fedwiredirectory.frb.org/search.cfm
and check whether the bank name is appearing or not.

how do it in excel macro ?

 

[Tim Williams]

You could automate IE to do this. Google (in Groups) for "VB[A] automate
IE" and you'll get some examples.

Tim

suppose in A2 I have routing number 021000021, similarly there are 100
routing numbers in A3 to A100

I will check those routing number in
http://www.fedwiredirectory.frb.org/search.cfm
and check whether the bank name is appearing or not.

how do it in excel macro ?