Private Sub Command1_Click()
MsgBox "hhhe"
Call delrow
End Sub
Private Sub delrow(excelworkbook As Excel.Workbook) Dim excelApp As New Excel.Application
Dim excelWorksheet As Excel.Worksheet
Set excelWorksheet = excelworkbook.Sheets(1)
'excelWorksheet.Cells(2, 3) = "宏通" '写入数据
'excelWorksheet.Cells(3, 4) = "zyg365" '写入数据
'excelApp.Visible = True '显示excel界面,用于调试
'excelWorkBook.PrintPreview '打印预览
'excelWorkBook.PrintOut '打印输出
'excelWorkBook.Saved = True
'excelWorkBook.Close '关闭工作薄
'excelApp.Quit '退出excelDim x As Integer
Dim y As Integer
MsgBox "hhhe"
Call delrow
End Sub
Private Sub delrow(excelworkbook As Excel.Workbook) Dim excelApp As New Excel.Application
Dim excelWorksheet As Excel.Worksheet
Set excelWorksheet = excelworkbook.Sheets(1)
'excelWorksheet.Cells(2, 3) = "宏通" '写入数据
'excelWorksheet.Cells(3, 4) = "zyg365" '写入数据
'excelApp.Visible = True '显示excel界面,用于调试
'excelWorkBook.PrintPreview '打印预览
'excelWorkBook.PrintOut '打印输出
'excelWorkBook.Saved = True
'excelWorkBook.Close '关闭工作薄
'excelApp.Quit '退出excelDim x As Integer
Dim y As Integer
MsgBox "hhhe"
Call delrow(aaa)
End Sub
Private Sub delrow(excelworkbook As Excel.Workbook) Dim excelApp As New Excel.Application
Dim excelWorksheet As Excel.Worksheet
Set excelWorksheet = excelworkbook.Sheets(1)
Set aaa = excelWorksheet.Range("a:a,ab:af,at:av,cq:db")
aaa.DeleteEnd Sub
放哪里了?Private Sub Command1_Click()
dim aaa As Excel.Workbook
Call delrow(aaa)
End Sub
Private Sub delrow(excelworkbook As Excel.Workbook) Dim excelApp As New Excel.Application
Dim excelWorksheet As Excel.Worksheet
Set excelWorksheet = excelworkbook.Sheets(1)
Set excelworkbook = excelWorksheet.Range("a:a,ab:af,at:av,cq:db")
excelworkbook .Delete
MsgBox "hhhe"
Call delrow(ThisWorkbook)
End SubPrivate Sub delrow(excelworkbook As Excel.Workbook) Dim excelApp As New Excel.Application
Dim excelWorksheet As Excel.Worksheet
Set excelWorksheet = excelworkbook.Sheets(1)
Set aaa = excelWorksheet.Range("a:a,ab:af,at:av,cq:db")
aaa.DeleteEnd Sub
放哪里了?
"kernel32" Alias "WritePrivateProfileStringA" _
(ByVal AppName$, ByVal KeyName$, ByVal _
keydefault$, ByVal FileName$)