7,785
社区成员




Private Sub Command1_Click()
Dim xlApp As New Excel.Application '定义并创建EXCEL对象
Dim xlBook As Excel.Workbook '创建工作簿
'xlapp.DisplayAlerts =False
xlApp.Visible = True '让Excel可见
Set xlBook = xlApp.Workbooks.Open(App.Path & "/dot.xls") '打开Excel模板
With xlBook.ActiveSheet
.Range("b4") = Text1.Text '填充第一行第一列的值
.Range("i4") = Text2.Text ' 填充其他行列的值,具体的填充位置得根据模板来做
End With
xlBook.ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True, Password:=1234 '表格设定密Set excel_Book = excel_App.Workbooks.Open(App.Path & "\dot.XLS")
ChDir "D:\评定表牧牛科技"
Dim a As Long
xlBook.SaveAs FileName:="D:\评定表牧牛科技\" & Text1.Text & Text2.Text & ".xlsx", FileFormat:= _
xlOpenXMLWorkbook, CreateBackup:=False
xlApp.Quit
Set xlApp = Nothing
End Sub