Click here to Skip to main content
16,018,249 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi,

please help me to code using VB which has the following inputs on a form:

INPUTS IN A FORM:
1>Mobile no: corresponding to it is a textbox
2>Call Origin: corresponding to it is a drop-down box in which option re as MOC(Mobile Originated Call) and TOC(Trunk Originated Call)
3>Tree to be processed: corresponding to it is a textbox in which default value is set as Tree2.user cannot enter any other value in it else it should prompt for an error

I want my output in a list box as pre-analysis processed
and a modified 10 digit mobile no.

when user enters a mobile no or landline no. in 1st input for e.g +919920...... and selects MOC type of call from 2nd input it will search in relevant MS-excel database the type of call column according to input entered and chop the digits as specified in No. of removed digits column and display me a 10 digit mobile no. in listbox after cutting off the country code.

Please help
Posted

1 solution

The simplest way would be to connect to the Excel spreadsheet as if it were a database using ADO.


Then write SQL to get the data you want.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900