注册 登录
编程论坛 VB6论坛

求教vb建excel表格

leajay755826 发布于 2012-11-13 09:13, 773 次点击
有一些数据想通过vb做成表格。能增加删除。
8 回复
#2
ccwu22012-11-13 12:44
这样?
程序代码:

Option Explicit

Private Declare Function SetParent Lib "user32" (ByVal hWndChild As Long, ByVal hWndNewParent As Long) As Long
Private Declare Function MoveWindow Lib "user32" (ByVal hwnd As Long, ByVal x As Long, ByVal y As Long, ByVal nWidth As Long, ByVal nHeight As Long, ByVal bRepaint As Long) As Long
Private Declare Function FindWindow Lib "user32" Alias "FindWindowA" (ByVal lpClassName As String, ByVal lpWindowName As String) As Long

Dim pid As Long

Private Sub Form_Load()
Dim xlApp As Excel.Application, xlBook As Excel.Workbook, xlsheet As Excel.Worksheet
   
    Me.Height = 10245
    Me.Width = 11745
    Set xlApp = CreateObject("Excel.Application")
    xlApp.Visible = True
    Set xlBook = xlApp.Workbooks.Add
    pid = FindWindow("XLMAIN", "Microsoft Excel - Book1")
    SetParent pid, Me.hwnd
    MoveWindow pid, 0, 0, 780, 650, True
    Set xlsheet = xlBook.Sheets(1)
    xlsheet.Activate
   
End Sub

Private Sub Form_Unload(Cancel As Integer)
    Call KillProcess("EXCEL.EXE")
    Unload Me
End Sub
#3
Artless2012-11-13 12:53
直接用excel吧
#4
ccwu22012-11-13 13:19
难道有更简单的方法满足他的需求?

通过vb
建excel表格
能增加删除
#5
ccwu22012-11-13 13:29
我收回~还真有更简单的~
一个代码都不用写~
只有本站会员才能查看附件,请 登录
#6
thera282012-11-22 14:09
这是怎么加进去的呢,还是看不懂啊
#7
曙光电子2012-11-22 19:42
回复 5楼 ccwu2
说说你的操作过程?
#8
曙光电子2012-11-22 19:47
我知道了,添加VB自带有这个控件!
#9
ccwu22012-11-23 10:17
以下是引用曙光电子在2012-11-22 19:47:42的发言:

我知道了,添加VB自带有这个控件!


yes,所以拉出来就好,一个代码都不用写,就有了
1