Thread: Searching an Excel Document

I have read the FAQ and even followed the link to the C++ beginner area and found no help. Is there a way for a program to search a Microsoft Excel document in 2 columns. It would search from a CString input of m_strProv1Num as a match for something in column B of the excel document. When it reads the correct match, it reads the value in column A and writes it back into the CString variable of m_strProv1Name and updates the view to show the name. Any help on this topic would be appreciated.

Also, is there a way to incorporate a progress bar so that it is a visual aid of just how much has been searched?

Thanks for your time.

~Brett Patterson

Perhaps instead of using Microsoft Excel as my medium of transportation, how about a database? I mean create a new SDI application that is the database. All the numbers are stored as somethinglike CString m_strNUMBER, and the variable would be strNumber. Would I be able to create a second SDI application that would be able to search all the inputs of the strNumber variable in the Numbers. It would be an ever growing number of numbers and names. That is my first thing that needs to be settled. I would say that if I can do this, then I would later need help on being able to read the number and retrieve the name associated with that number. For example:

Name: |Brett Patterson| //m_strName
ID Number: |0011182| //m_strNumber
Certification: |EMT-B| //m_strCertification
Affiliation: |14| //m_strAffiliation

From that database, I would wnat to be able to type into an edit box the number "0011182" and then have that go back into the other program, search for the exact match of the number, read the m_strName field, pull that field into the program and display it as a non-edit or disabled Edit field of m_strProvider1.

First things first though. I am still confused about how to actually connect the database to my other program and just how to have the new program read from the database and copy field strings to another program. Please help me if you can. Any help would be appreciated.