Question

别人给我写的一个程序 Set a = CreateObject("Excel.Application")没看懂

Private Sub Form_Load()
Dim a As Object
Dim b As Object
Dim c As Object
Set a = CreateObject("Excel.Application") ‘这是什么意思啊？？？？？？？
Set b = a.Workbooks.Add
Set c = b.Worksheets(1)
b.SaveAs App.Path & "\" & c.Name & ".xlsx"
'b.saveAs App.Path & "\" & c.Cells(1,1).value & ".xlsx"
a.Visible = False
End Sub

Answer 1

Set a = CreateObject("Excel.Application")
建立一个excel模型给a
下面a就相当于开着excel，可以用它下面的命令
Workbooks.Add 新增工作簿 等等

Answer 2

把 a 定义成一个EXCEL对象。
这样 Workbooks 的属性才能属于a.