用DAOhttp://vbboshi.myrice.com/vbtech/database/page_3/file87.htm
解决方案 »
- 简单问题,关于如何读注册表
- 请问:在ListView空间的“报表”视图中如何显示网格?
- Private m_Font As StdFont,这一句报错,提示用户定义类型未定义,我应该引用什么才行呀?
- 100分~急问!如何编写托盘程序~
- UpdateBatch的使用
- 请问考试系统中word、excel部分的自动评分功能怎么实现呀?
- 我要打印如下数据,请问如何实现?
- 【求助】代码出现错误438,求解!
- 怎么样能把flash动画充满一个from呢~?怎么能把flash动画加入vb from呢~?大家也都好晚:)xixi
- 有谁能把歌词写入MP3文件中,在播放时又能取出来???
- 急用!!!请帮忙!!!
- 请问:mid函数如何使用
'把记录集的内容保存到excel文件中
Dim oExcel As Excel.Application
Dim oBook As Excel.Workbook
Dim oSheet As Excel.Sheets
Dim j As Long, i As Long Set oExcel = CreateObject("Excel.Application")
Set oBook = oExcel.Workbooks.Add
Set oSheet = oBook.Worksheets(1)
'#########方法一######################
lSumRecord = 0
' On Error Resume Next
While Not Rs.EOF
j = j + 1
pgbRead.Value = j
For i = 0 To Rs.Fields.Count - 2
oSheet.Range(Trim(Chr(97 + i)) & CLng(j)) = Trim(Rs.Fields(i + 1))
DoEvents
Next
lSumRecord = lSumRecord + 1
Rs.MoveNext
DoEvents
Wend
pgbRead.Value = 1
'#########方法二#######################
' oSheet.Range("A").CopyFromRecordset Rs
If chkHavePassword.Value Then
oBook.SaveAs vFilename, , sRPassword, sWPassword
Else
oBook.SaveAs vFilename
End If
oExcel.Quit
Set oSheet = Nothing
Set oBook = Nothing
Set oExcel = Nothing
End Function
xlbool.close false