Searching in Excel Database Using VB6

See more:

VB6

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