Dim hwnd As Long Dim i As Integer, j As Integer hwnd = FindWindow("XLMAIN", 0) If hwnd = 0 Then '0 表示没有 Excel 在运行。 GoTo cas Else MsgBox "请先关闭正在运行的EXCEL!", 64, "提示信息" Exit Sub End If cas: Set xlapp = CreateObject("Excel.Application") Set xlapp = xlapp.Workbooks.Add xlapp.Parent.Windows(1).Visible = True '使父窗体可见 Set xlsheet = xlapp.application.Worksheets(1) '当前工作簿的第一页
For i = 0 To Grid1.Rows - 1 Grid1.Row = i For j = 0 To Grid1.Cols - 1 Grid1.Col = j xlsheet.Cells(i + 1, j + 1).Value = Grid1.Text Next Nextxlsheet.Columns("b:IV").AutoFit 'a到i列自动调整列宽 Call GetExcel
objExcelSheet1.Range("A2:A2") = objExcelSheet1.Pictures.Insert("图片路径").Select
objExcelSheet1.Range("B3:F3") = "文本"
它们可随便落动位置,应该是独立的一个对象!这类语句应该与赋值行列语句有所不同!书上又找不到相关的例子!是不是没有这些功能哦!
Dim i As Integer, j As Integer
hwnd = FindWindow("XLMAIN", 0)
If hwnd = 0 Then '0 表示没有 Excel 在运行。
GoTo cas
Else
MsgBox "请先关闭正在运行的EXCEL!", 64, "提示信息"
Exit Sub
End If
cas:
Set xlapp = CreateObject("Excel.Application")
Set xlapp = xlapp.Workbooks.Add
xlapp.Parent.Windows(1).Visible = True '使父窗体可见
Set xlsheet = xlapp.application.Worksheets(1) '当前工作簿的第一页
For i = 0 To Grid1.Rows - 1
Grid1.Row = i
For j = 0 To Grid1.Cols - 1
Grid1.Col = j
xlsheet.Cells(i + 1, j + 1).Value = Grid1.Text
Next
Nextxlsheet.Columns("b:IV").AutoFit 'a到i列自动调整列宽
Call GetExcel
Excel的文本框1----- excel_app.ActiveSheet.Cells(1, 1) = RichTextBox1.Text
Excel的矩形 1----- excel_app.ActiveSheet.Range("A1")
保存图片用shapes集合
Call excel_sheet.Shapes.AddPicture(FileName:="E:\image\image\check_member.gif", linktofile:=msoTrue, savewithdocument:=msoTrue, Left:=100, Top:=100, Width:=70, Height:=70)