Results 1 to 2 of 2

Thread: VB and XLS Object

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    Oct 2001
    Location
    Miami, Florida
    Posts
    161

    Question 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

  2. #2

    Thread Starter
    Addicted Member
    Join Date
    Oct 2001
    Location
    Miami, Florida
    Posts
    161
    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
  •  



Click Here to Expand Forum to Full Width