调用Book1.xls里的test过程:
Private Sub Command1_Click()
With CreateObject("excel.application")
.workbooks.open App.Path & "\book1.xls"
.run "book1.xls!test"
.workbooks("book1.xls").Close False
.quit
End With
End Sub
调用Book1.xls里的test过程:
Private Sub Command1_Click()
With CreateObject("excel.application")
.workbooks.open App.Path & "\book1.xls"
.run "book1.xls!test"
.workbooks("book1.xls").Close False
.quit
End With
End Sub
您好:想你请教个问题;
下面代码格式改成普通格应该怎样写啊?(也就是不要 with.......end with )谢谢
Private Sub Command1_Click()
With CreateObject("excel.application")
.Visible = True
.Workbooks.Open App.Path & "\book1.xls"
.Run "book1.xls!test"
'.workbooks("book1.xls").Close False'不保存文件
'.workbooks("book1.xls").Close True'保存文件
'.quit
End With
End Sub