-
VB and XLS Object
I am trying to build an on leave field that can do the following. In a current form I have a field called SSN, upon leaving the field I would like a search to look at an xls spreadsheet for a field also called SSN and find the equal value "match" and then proceed to delete the row. Prior to deleting the row a dialog prompt should display first name, last name, ssn, and ask to confirm delete.
The field name on the XLS is on a column also called SSN.
Can anyone show me a sample on how to code this?
I am trying to learn how to interact with XLS.
Thanks
-
What I want to do is to have "VB" use XLS objects to accomplish a search on my spreadsheet "Excel", and finally delete XLS row.
Example:
A user enters a value on the SSN field in a VB front end. Upon leaving the VB SSN field or a button, I would like for the code behind the SSN field "xls object" to search an Excel spreadsheet to find a column called SSN containing an equal value entered on the VB front end. If no value is found, display a dialog box saying SSN number does not exist on spreadsheet else upon finding the value, display dialog box with fname, lname, ssn and confirm delete of row on spreadsheet.
Thanks