✔ 最佳答案
'版本VB6
'先至引用項目將"Microsoft EXCEL 11.0引用"
'Form上面加入一個Command1即可
Private Sub Command1_Click()
Dim objXL As Excel.Application
Set objXL = CreateObject("EXCEL.Application")
objXL.Visible = True
Set wbXL = objXL.Workbooks.Add
Set wsXL = objXL.ActiveSheet
End Sub
2010-12-24 09:25:04 補充:
以下輸入要建立幾個xls由user去訂,比如說輸入3,就存成1.xls 2.xls 3.xls 三個檔案
2010-12-24 09:25:22 補充:
Private Sub Command1_Click()
Dim i As Integer, i2 As Integer
Dim objXL As Excel.Application
Dim wbXL As Excel.Workbook
Set objXL = CreateObject("EXCEL.Application")
objXL.Visible = False
i2 = InputBox("你想存幾個")
2010-12-24 09:25:27 補充:
For i = 1 To i2
Set wbXL = objXL.Workbooks.Add
wbXL.SaveAs "e:\test\" & i & ".xls"
wbXL.Close
Next
Set wbXL = Nothing
End sub
2010-12-24 09:26:11 補充:
注意:以上並未去處理同檔名該如何處理,請小心使用。