VB6 and Creating and Excel spreadsheet
Posted on 2005-04-15
i'm trying to create an excel spreadsheet which only has 1 sheet (the normal default is 3 sheets). I have tried to remove the extra two sheets, but Excel generates a warning when you try to delete the sheet, and I don't want my customer to have to worry about the warning. I'm going to be adding sheets (which I can do without problems), sheet 1 will be a title page, then I will be adding 1 new sheet for each item in a database, and I don't want those extra two sheets in the workbook. Does anyone have any ideas about this? Thanks in advance for your help.