请问何如使用VB将一数据文本文件导入 EXCEL ?
abc.TXT
Tom 1000 3.15
Jone 300 4.00
Mike 415 0.89
abc.TXT
Tom 1000 3.15
Jone 300 4.00
Mike 415 0.89
解决方案 »
- [求助]如何解压缩Zip文件?
- 高分请教,指定打印机打印!
- 关于Listbox的滚动条的?
- 连通检测 ---本计算机是否与internet相连通
- 为什么在vc中写的有事件的类在vb中用WithEvents声明后初始化时会出459号错误??
- 报表问题,急!急!
- 请问浮动的提示窗口如何做出?
- 谁遇到过VB6的制作的安装包安装时Setup出错,不能安装的情况?高分赠高手!
- 请教:如何用一个按钮执行adodc改变sql查询语句,并使adodc执行改变后的指令?
- 关于数据记录的增加
- 我想让一个控件每秒钟置前一次,怎么办?(在线)
- ?在vb6.0中,请问用哪个功能可以从一个字中分离出其中的某一位来用?先谢谢了!
Dim i As Integer
Dim intRow As Integer
Dim intColumn As Integer
Dim intfnum As Integer
Dim strLine As String
Dim varLine As VariantDim xlApp As New Excel.Application
Dim xlWorkbook As Excel.Workbook intfnum = FreeFile() '打开文本文件
Open "c:\abc.txt" For Input As #intfnum Set xlWorkbook = xlApp.Workbooks.Add intRow = 0
Do While Not EOF(intfnum)
intRow = intRow + 1
Line Input #intfnum, strLine '读文本文件一行
varLine = Split(strLine, " ") '以空格为分隔符
intColumn = 0
For i = 0 To UBound(varLine)
If varLine(i) <> vbNullString Then
intColumn = intColumn + 1
xlWorkbook.Worksheets(1).Cells(intRow, intColumn) = varLine(i)
End If
Next
Loop xlWorkbook.SaveAs "c:\abc.xls" '保存Excel文件后退出
xlApp.Quit
Set xlApp = Nothing
Set xlWorkbook = Nothing Close '关闭文本文件 Unload Me
End Sub
Wait me trying...
没有找到 Microsoft Excel Object Libray
我用的是 OfficeXP
选择VB菜单 工程(Project)—— >引用(Reference)—— >Microsoft Excel 10.0 Object Libray,按确定(OK)。
Dim i As Integer
Dim intRow As Integer
Dim intColumn As Integer
Dim intfnum As Integer
Dim strLine As String
Dim varLine As VariantDim xlApp As Object
Dim xlWorkbook As Object intfnum = FreeFile() '打开文本文件
Open "c:\abc.txt" For Input As #intfnum set xlApp=CreateObject ("Excel.Application")
set xlWorkbook = xlApp.Workbooks.Add intRow = 0
Do While Not EOF(intfnum)
intRow = intRow + 1
Line Input #intfnum, strLine '读文本文件一行
varLine = Split(strLine, " ") '以空格为分隔符
intColumn = 0
For i = 0 To UBound(varLine)
If varLine(i) <> vbNullString Then
intColumn = intColumn + 1
xlWorkbook.Worksheets(1).Cells(intRow, intColumn) = varLine(i)
End If
Next
Loop xlWorkbook.SaveAs "c:\abc.xls" '保存Excel文件后退出
xlApp.Quit
Set xlApp = Nothing
Set xlWorkbook = Nothing Close '关闭文本文件 Unload Me
End Sub
你是按照我2003-5-16 19:29:52 介绍的步骤做的吗?
选择VB菜单 工程(Project)—— >引用(Reference)—— >Microsoft Excel 10.0 Object Libray,按确定(OK)。没有找到。
到此为止。