| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Web Query
Hi,
I have data in 10 columns. In a column I have data related to some codes take an example of routing numbers. Suppose user provided 10 routing number in a specified column. I need to validate, entered routing number is valid or not. For that I will copy the routing number and I will check in web site. To minimize the time any macro can be assigned to validate whether the mentioned routing number is valid or not ? waiting for solutions. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Web Query
On May 17, 4:47*pm, muddan madhu wrote:
Hi, I have data in 10 columns. In a column I have data related to some codes take an example of routing numbers. Suppose user provided 10 routing number in a specified column. I need to validate, entered routing number is valid or not. For that I will copy the routing number and I will check in web site. To minimize the time any macro can be assigned to validate whether the mentioned routing number is valid or not ? waiting for solutions. Hi, You can loop all the nos you want to validate and feed the same to web query and perse the results as required. Regards, Madiya |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 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) | |||
| How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
| Stop to modify the SQL query manually entered into query ! | Excel Programming | |||
Hybrid Mode
