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