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.