|
本帖最后由 文轩馨婷 于 2014-4-10 13:12 编辑
要求:
如何在下面编程中在Strsheetname1 表中点击按钮自动生产Strsheetname2 表,当再次在Strsheetname1 表中点击按钮时会弹出提示框“已生成了Strsheetname2 ,是否重新生成”;并且重新生成后原已生成的Strsheetname2 表将被再次生成的表替代!
Option Explicit
Dim Strsheetname1 As String, Strsheetname2 As String, Ilen As Integer
Sub Chapter13()
Strsheetname1 = ActiveSheet.Name '
Ilen = Len(Strsheetname1) '
Sheets.Add after:=Sheets(Strsheetname1) '
Strsheetname2 = Left(Strsheetname1, Ilen) + "工资条"
ActiveSheet.Name = Strsheetname2
Chapter13_1 '
End Sub
本帖最后由 810126769 于 2014-4-10 13:01 编辑
再简化一下: - Option Explicit
- Dim Strsheetname1 As String, Strsheetname2 As String, Ilen As Integer
- Sub Chapter13()
- Dim sh As Worksheet
- Application.DisplayAlerts = False
- Strsheetname1 = ActiveSheet.Name '
- Ilen = Len(Strsheetname1) '
- Strsheetname2 = Left(Strsheetname1, Ilen) + "工资条"
- For Each sh In Sheets
- If sh.Name = Strsheetname2 Then
- If MsgBox("已生成了Strsheetname2 ,是否重新生成", vbOKCancel) = 1 Then
- Sheets(Strsheetname2).Delete
- Else
- Exit Sub
- End If
- Exit For
- End If
- Next sh
- Sheets.Add after:=Sheets(Strsheetname1) '
- ActiveSheet.Name = Strsheetname2
- Sheets(Strsheetname1).Activate
- Chapter13_1 '
- Application.DisplayAlerts = True
- End Sub
复制代码
|
|