VBA Query
 

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 ?

VBA Query
 

More detail along with url, etc


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"muddan madhu" wrote in message
...
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 ?

VBA Query
 

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 ?


On Jun 5, 11:15*pm, "Don Guillett" wrote:
More detail along with url, etc

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"muddan madhu" wrote in message

...



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 ?- Hide quoted text -

- Show quoted text -

VBA Query
 

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

"muddan madhu" wrote in message
...
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 ?


On Jun 5, 11:15 pm, "Don Guillett" wrote:
More detail along with url, etc

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"muddan madhu" wrote in
message

...



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 ?- Hide quoted text -

- Show quoted text -

VBA Query
 

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

Tim

"muddan madhu" wrote in message
...
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 ?


On Jun 5, 11:15 pm, "Don Guillett" wrote:
More detail along with url, etc

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"muddan madhu" wrote in
message

...



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 ?- Hide quoted text -

- Show quoted text -