Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 ? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 ? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 - |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 - |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import New Database Query (Union Query) in Spreadsheet | Excel Discussion (Misc queries) | |||
Convert hard coded query criteria to Parameter Query | Excel Discussion (Misc queries) | |||
Excel 2007 / MS Query - editing existing query to another sheet | Excel Discussion (Misc queries) | |||
Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
Stop to modify the SQL query manually entered into query ! | Excel Programming |