打开一个Excel文件,选择菜单栏上的"Tools"选项->Macro->Visual Basic Editor,打开VBA编辑器。
在Modules文件夹下的csMain文件中,写下如下VB格式的代码:
Dim xlApp As Excel.Application Dim xlBook As Excel.Workbook Set xlApp = New Excel.Application Set xlBook = xlApp.Workbooks.Open("C:\test.xls") Dim sheet As Excel.Worksheet Set sheet = xlBook.Worksheets(2)
|