如何在vb中运行excel中的宏
在excel中已经创建了一个宏,如何在vb中运行它。谢谢 --------------------编程问答-------------------- Macro1是创建的宏名, hello是给macro1的参数
Dim oExcel As Excel.Application
Dim oWorkbook As Excel.Workbook
Set oExcel = New Excel.Application
oExcel.Visible = True
Set oWorkbook = oExcel.Workbooks.Open("c:\macrotest.xls")
oWorkbook.Application.Run "Macro1", "hello"
oWorkbook.Save
oExcel.Quit
--------------------编程问答-------------------- 学习,顶 --------------------编程问答-------------------- 谢谢了,帮我解决了这个问题 --------------------编程问答-------------------- ok --------------------编程问答-------------------- 不错
补充:VB , 基础类