Dim x As Object, xbook As Object, xsheet As Object
Set x = CreateObject("excel.application") '创建EXCEL应用程序对象,启动EXCEL应用程序
Set xbook = x.workbooks.Add '新建一个工作簿,并将其赋给xbook
Set xsheet = xbook.worksheets(1) '将xbook工作薄中的第一个表赋给xsheet
x.Visible = True '让EXCEL可视
xsheet.Cells(1, 1) ="=SUM(I10:J67)" '在需要录入公式的单元格将公式以字符串的形式写入即可。