为什么没人理?CSDN现在到底怎么了?
解决方案 »
- 字符串不能作为条件么
- Vista仅获8%软件开发人员支持 前景堪忧
- 有谁用过这个BarCodeCtrl控件(关于条形码的,VB里的ActiveX控件),有一个小问题。急急急!
- 开发捕获程序的问题,望大虾指点阿!
- 查找指定窗体(知道Caption的前几个字符)返回窗体句柄用哪(几)个API?
- 关于RICHTEXTBOX的一个问题?
- 我想问一下我VB目录下的controls.vpb(工程文件)文件没有了怎么办?请高手们指教指教!!
- 请教关于MSHFLEXGRID控件的使用
- 我的电脑为啥总是死机
- listbox控件没有ScaleMode属性 如何保持与form的相同
- ActiveReports在WIN2K下,LQ-1600 难道不能打印出高度为70mm的页面
- 怎样最小化当前所有窗口
'------------------------$$$$$$$ In Proc
If lvwList.ListItems.Count = 0 Then GoTo ExitProc
Screen.MousePointer = vbHourglass
' On Error GoTo eerer
Dim vbExcel As Object
Dim vbWorkSheet As Object
Dim RG As Object
Set vbExcel = CreateObject("Excel.application")
vbExcel.Workbooks.Add
vbExcel.Sheets.Add
Set vbWorkSheet = vbExcel.ActiveSheet
vbWorkSheet.Name = "." & App.Title
vbWorkSheet.Cells(1, 3).NumberFormatLocal = "@"
vbWorkSheet.Cells(1, 3).Value = Trim(sTitle$)
vbWorkSheet.Cells(1, 3).Font.Size = 15
vbWorkSheet.Cells(1, 3).Font.Bold = True
Dim rr%, kk%
rr = 3
If sAddCond <> "" Then
vbWorkSheet.Cells(3, 2).NumberFormatLocal = "@"
vbWorkSheet.Cells(3, 2).Value = Trim(sAddCond)
rr = 4
End If
Dim LC&
Dim LC1&
Dim tlngAlign As Long
For LC = 1 To lvwList.ColumnHeaders.Count
With vbWorkSheet.Cells(rr, LC + 1)
.NumberFormatLocal = "@"
.Value = lvwList.ColumnHeaders(LC).Text
.Font.Bold = True
tlngAlign = lvwList.ColumnHeaders(LC).Alignment
.HorizontalAlignment = Switch(tlngAlign = 0, &HFFFFEFDD, tlngAlign = 2, &HFFFFEFF4, tlngAlign = 1, &HFFFFEFC8)
.VerticalAlignment = &HFFFFEFF4
End With
Next LC
kk = 2
For LC& = 1 To lvwList.ListItems.Count
With vbWorkSheet.Cells(rr + LC, kk)
.NumberFormatLocal = "@"
tlngAlign = lvwList.ColumnHeaders(1).Alignment
.HorizontalAlignment = Switch(tlngAlign = 0, &HFFFFEFDD, tlngAlign = 2, &HFFFFEFF4, tlngAlign = 1, &HFFFFEFC8)
.VerticalAlignment = &HFFFFEFF4
.Value = lvwList.ListItems(LC)
End With
For LC1 = 1 To lvwList.ColumnHeaders.Count - 1
With vbWorkSheet.Cells(rr + LC, kk + LC1)
.NumberFormatLocal = "@"
tlngAlign = lvwList.ColumnHeaders(LC1 + 1).Alignment
.HorizontalAlignment = Switch(tlngAlign = 0, &HFFFFEFDD, tlngAlign = 2, &HFFFFEFF4, tlngAlign = 1, &HFFFFEFC8)
.VerticalAlignment = &HFFFFEFF4
.Value = lvwList.ListItems(LC).SubItems(LC1)
End With
Next LC1
Next LC&
'-------------***********wang
If Not (XtChart Is Nothing) Then
vbWorkSheet.Cells(rr + LC + 1, kk).Activate
XtChart.EditCopy
vbWorkSheet.PasteSpecial "位图"
vbWorkSheet.Shapes(vbWorkSheet.Shapes.Count).Width = XtChart.Parent.ScaleX(XtChart.Width, vbTwips, vbPoints)
Clipboard.Clear
End If
'-------------***********wang
vbExcel.Visible = True
vbWorkSheet.Activate Set RG = Nothing
Set vbExcel = Nothing
Set vbWorkSheet = Nothing
Screen.MousePointer = vbDefault
sTitle 是标题, lvwList 是ListView