RT
解决方案 »
- 水晶報表的打印設定
- 谁来帮帮我?
- 在sql 语句中如何实现大小写匹配???????????
- 巨分寻软件Spread 6.0
- 一个关于Netmeeting SDK的问题
- 100分:我想问一下ADODB的Stream属性应该怎么定义和引用的-----万分感谢。
- 高分求助!
- 相问个问题:在程序的几个窗口中都有同样的代码,我怎样才能做到重用它们,不再重写?
- 如何制作边缘任意形状的窗体?
- 请问:用VB写这样的程序如何实现:在局域中有一台机器上网,其他机器(或指定的一台)也能共享上网。注意这个程序是要自己写。
- 求救!怎样把SQL数据库中的数据导出到文本文件(.TXT)?急!在线等.
- 请教:在VB中如何获取系统盘
Dim xlApp As Excel.Application
Dim xlBook As Excel.Workbook
Dim xlSheet As Excel.Worksheet
Dim i As Long, j As Long
On Error GoTo ErrorHandle
Set xlApp = CreateObject("Excel.Application")
Set xlBook = xlApp.Workbooks.Add
Set xlSheet = xlBook.Worksheets(1)
xlSheet.Name = Sheet_Name
xlSheet.StandardWidth = 8 '设定默认列宽
xlSheet.Range("A1", "Z900").Font.Bold = False '设定范围内的字体是否加粗
xlSheet.Range("A1", "Z900").Font.Size = 9 '设定字体大小
xlSheet.Range("A1", "Z900").HorizontalAlignment = xlLeft '设定对齐方式
xlSheet.Range("a1", "z1").Font.Bold = True '设定第一行为加粗
For i = 0 To MHFGrid.Rows - 1
For j = 0 To MHFGrid.Cols - 1
xlSheet.Cells(i + 1, j + 1).Value = Trim(MHFGrid.TextMatrix(i, j))
Next j
Next i xlSheet.Application.Visible = True
'xlBook.Close
Set xlSheet = Nothing
Set xlBook = Nothing
Set xlApp = Nothing
Exit Sub
ErrorHandle:
MsgBox "错误:" & Err.Number & vbCrLf & Err.Description, vbOKOnly, "运行错误"End Sub
Dim FileName As String
Set excelWorkbook = excelApplication.Workbooks.Open(App.Path & "\spcbmxb.xls")
Set excelSheet = excelWorkbook.Sheets("物语出品成本明细表")
excelSheet.Cells(3, "J") = lblTC.Caption
I = 0
For I = 0 To (msList.Rows - 1) Step 1
excelSheet.Cells(I + 4, "A") = msList.TextMatrix(I, 0)
excelSheet.Cells(I + 4, "B") = msList.TextMatrix(I, 1)
excelSheet.Cells(I + 4, "C") = msList.TextMatrix(I, 2)
excelSheet.Cells(I + 4, "D") = msList.TextMatrix(I, 3)
excelSheet.Cells(I + 4, "E") = msList.TextMatrix(I, 4)
excelSheet.Cells(I + 4, "F") = msList.TextMatrix(I, 5)
excelSheet.Cells(I + 4, "G") = msList.TextMatrix(I, 6)
excelSheet.Cells(I + 4, "H") = msList.TextMatrix(I, 7)
excelSheet.Cells(I + 4, "I") = msList.TextMatrix(I, 8)
excelSheet.Cells(I + 4, "J") = msList.TextMatrix(I, 9)
Next
FileName = SaveExcelName("物语月份成本明细报表")
If FileName = "" Then
Exit Sub
End If
excelWorkbook.SaveCopyAs (FileName)
excelWorkbook.Close (False)
Set excelWorkbook = Nothing
Set excelApplication = NothingPublic Function SaveExcelName(vFileName As String) As String
With Saved
.DialogTitle = "保存Excel文件"
.FileName = vFileName
.Filter = "Microsfot Excel 文件|*.xls"
.InitDir = App.Path
.ShowSave
End With
SaveExcelName = Saved.FileName
End Function加个commondialog控件来控制保存路径,其他的格式可以通过excel的宏来生成。