Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Posts
    7

    Talking Unanswered: Junior developer in need of help....

    First.. I'm NOT an Excel guy. NO VBA please! This must be in VB6 code.

    Now then .. :-)

    I get sent an excel file from a client. Sometimes it is multiple worksheets. I have an existing VB6 application running on MS SQL Server database.

    I need to open each record in the Excel file, which is checked via email address...

    If an email address already exists in SQL - flag the user with a warning message.....

    If an email address does not exist - generate new unique identifyer and update the spreadsheet with this new ID....

    I need some specific example code, and not (necessarily) pointers to KB articles, etc. This is my FIRST time dealing with this subject, so PLEASE be kind.

    Thank you for your help -....

  2. #2
    Join Date
    Jan 2003
    Location
    New York
    Posts
    160
    1 - For the excel file, when you say you get multiple worksheets at a time, do you know the names of those sheets ?

    2 - When you say flag the user, flag it in the sql server or in the excel file ?


    i did vb6 with excel (as a bullshit database) so i have the code, just need to know how specific you want to get
    Beyond Limitation

  3. #3
    Join Date
    Nov 2003
    Posts
    7

    Talking Wow....thanks...

    Originally posted by vextout
    1 - For the excel file, when you say you get multiple worksheets at a time, do you know the names of those sheets ?

    2 - When you say flag the user, flag it in the sql server or in the excel file ?


    i did vb6 with excel (as a bullshit database) so i have the code, just need to know how specific you want to get
    Hi vextout,

    Thank you for your reply.....

    In answer to your questions -

    1. Basically - I have to open an excel file [ i.e. need to allow the user to navigate to where the file is stored and allow them to open it.] - the workbook usually consists of only 1 relevant worksheet, but I need to keep in mind the fact that it is not impossible for it to consist of more than 1. [hope you get what I mean?]

    2. I would be flaging the user from Visual basic...

    Thanks for your comeback......and thanks for your help.....

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •