Excel, Worksheet delete problem

Worksheet delete problem

Author	Message
Stephen Gear #1 / 5	Worksheet delete problem Can anyone tell me why the following VB6 code does not delete the first sheet in the workbook? It should do. Dim xlSummary as New Excel.Application Dim wkbSummary as Excel.Workbook Set xlSummary = New Excel.Application xlSummary.Workbooks.Open filename.xls Set wkbSummary = xlSummary.ActiveWorkbook wkbSummary.Worksheets(1).Delete I am running VB6 and MS Offixe XP under WinXP Pro, and yes the project does reference the MS Excel 10.0 Object Library
Thu, 08 Jul 2004 15:46:40 GMT

Davi #2 / 5	Worksheet delete problem Try This: Sub Macro1() Dim xlSummary As Workbook Dim wkbSummary As Worksheet Set xlSummary = ActiveWorkbook Set wkbSummary = xlSummary.Worksheets(1) wkbSummary.Delete End Sub Quote: >-----Original Message----- >Can anyone tell me why the following VB6 code does not delete the first >sheet in the workbook? >It should do. >Dim xlSummary as New Excel.Application >Dim wkbSummary as Excel.Workbook >Set xlSummary = New Excel.Application >xlSummary.Workbooks.Open filename.xls >Set wkbSummary = xlSummary.ActiveWorkbook >wkbSummary.Worksheets(1).Delete >I am running VB6 and MS Offixe XP under WinXP Pro, >and yes the project does reference the MS Excel 10.0 Object Library >.
Thu, 08 Jul 2004 16:58:53 GMT

Patrick Mollo #3 / 5	Worksheet delete problem ?????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????
Thu, 08 Jul 2004 17:39:38 GMT

Rob Bove #4 / 5	Worksheet delete problem That's a pretty tough question, mate. Don't know if I have an answer. -- Rob Bovey, MCSE, MCSD, Excel MVP Application Professionals http://www.appspro.com/ * Please post all replies to this newsgroup * * I delete all unsolicited e-mail responses * ???????????????????????????????????????????????????????????????????????????? ?????????????????????????????????????????????????????????
Thu, 08 Jul 2004 18:23:03 GMT

Tom Ogilv #5 / 5	Worksheet delete problem Before Excel deletes a sheet, it puts up a warning dialog asking if you are sure. Did you account for this? Also, at least one sheet must be in the workbook - is this a one sheet workbook? Regards, Tom Ogilvy Quote: > Can anyone tell me why the following VB6 code does not delete the first > sheet in the workbook? > It should do. > Dim xlSummary as New Excel.Application > Dim wkbSummary as Excel.Workbook > Set xlSummary = New Excel.Application > xlSummary.Workbooks.Open filename.xls > Set wkbSummary = xlSummary.ActiveWorkbook > wkbSummary.Worksheets(1).Delete > I am running VB6 and MS Offixe XP under WinXP Pro, > and yes the project does reference the MS Excel 10.0 Object Library
Fri, 09 Jul 2004 01:53:03 GMT

Page 1 of 1

[ 5 post ]