|
-
Oct 31st, 2001, 01:34 PM
#1
Thread Starter
Addicted Member
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
-
Nov 1st, 2001, 12:18 PM
#2
Thread Starter
Addicted Member
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|