VB6 – 5 simple routines to process Excel worksheet names

VB6 ??" 5 simple routines to process Excel worksheet names 1 Function Strsheetnames 2 Sub Deletesheets 3 Sub Addsheets 4 Sub Deletesheetsexcept 5 Sub Copysheets Dim xlsobj as workbook, xlsobj1 as workbook Both workbooks would have been instantiated with a Set statement. All operations should have alerts set false. The following should be provided: 1 Strnames = sheetnames(xlsobj) Returns a CSV string containing the names of the worksheets in xlsobj 2 Deletesheets xlsboj, strsheetstodelete Deletes the worksheets in xlsobj whose names are held as a CSV string in strsheetstodelete 3 Addsheets xlsobj, strsheetstoadd Adds worksheets to xlsobj, if not already present, with names held as a CSV string in strsheetstoadd 4 Deletesheetsexcept xlsobj, strexcepetions Deletes all sheets in xlsobj except those with names held as a CSV string in strexceptions. If strexceptions is empty, then all sheets are deleted. 5 Copysheets xlsobj, strsheetstocopy, xlsobj1 Copies the sheet or sheets whose names are held in CSV format in strsheetstocopy from xlsobj to xlsobj1. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform windows 2000/NT/XP