如何在VB中调用EXCEL打开*.XLS文件?
解决方案 »
- VB datagrid绑定了adodc.修改了datagrid数据后能不能不更新.具体代码
- CSDN是什么意思呀?
- 求助:根据excel文件名排序的问题。谢谢
- 如何判断一个字符串中的字符是数字还是字母
- 怎样设计一个象幸福之家那样的主登录界面?
- 怎么样得到adodc的记录条总数?
- 请问如何能获得网页表格里控件的name或id?
- 找个图标,就是大家将鼠标移动到超联接上面,那个小手的鼠标图标,谁发到我的信箱里,谢谢!!给50分。
- 我要把一个C程序改写成Basic的,但union联合在Basic里是用什么定义,或用什么代替
- 在VB6中能否编译标准的DLL,而非activex dll?
- 美女級問題!給20分。
- 怎么才能作一个等待窗口阿
Private Sub Form_Load()ShellExecute Me.hWnd, "open", "C:\User.xls", vbNullString, vbNullString, SW_SHOWEnd Sub
x.Workbooks.Open (Execl文件名)
x.Visible = True
Dim xlApp As Excel.Application
Dim xlBook As Excel.Workbook
Dim xlWorksheet As Excel.Worksheet
Dim xlActiveSheet As Excel.Worksheet
Dim strtemp(28), strFieldName(28) As String
Dim tmp_line As Integer
strtemp(1) = "A"
strtemp(2) = "B"
strtemp(3) = "C"
strtemp(4) = "D"
strtemp(5) = "E"
strtemp(6) = "F"
strtemp(7) = "G"
strtemp(8) = "H"
strtemp(9) = "I"
strtemp(10) = "J"
strtemp(11) = "K"
strtemp(12) = "L"
strtemp(13) = "M"
strtemp(14) = "N"
strtemp(15) = "O"
strtemp(16) = "P"
strtemp(17) = "Q"
strtemp(18) = "R"
strtemp(19) = "S"
strtemp(20) = "T"
strtemp(21) = "U"
strtemp(22) = "V"
strtemp(23) = "W"
strtemp(24) = "X"
strtemp(25) = "Y"
strtemp(26) = "Z"
strtemp(27) = "AA"
strtemp(28) = "AB"
Set xlApp = New Excel.Application
Set xlBook = xlApp.Workbooks.Open(App.Path & "\数据库.xls")
Set xlWorksheet = xlBook.Worksheets("sheet1")
Set xlActiveSheet = xlApp.ActiveSheet'读内容
tmp_line = 2Do
tttmp = ""
For i = 1 To 28
strFieldName(i) = Trim(xlBook.Worksheets("sheet1").Range(strtemp(i) & tmp_line).Value)
strFieldName(i) = Replace(strFieldName(i), "'", "''")
tttmp = tttmp & strFieldName(i) Next i
DoEvents If tttmp <> "" Then Else End If tmp_line = tmp_line + 1Loop Until Trim(tttmp) = "" '一共有多少行
'MsgBox xlActiveSheet.UsedRange.Rows.Count - 1
xlBook.Close
Set xlBook = Nothing
Set xlApp = Nothing
Set xlWorksheet = Nothing
Dim xlsWorkBook As Excel.Workbook
Dim xlsSheet As Excel.Worksheet Set xlsWorkBook = ExlApp.Workbooks.Open("e:\a.xls")
Set xlsSheet = xlsWorkBook.Worksheets(1)
ExlApp.Visible = True