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 -....

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.....