7,763
社区成员
发帖
与我相关
我的任务
分享
I_XlsSheet.Range("A1:AH5").Value'对象都已经创建,文件也已经打开,文件的这一部分有内容
'数据源对象
Dim I_XlsApp As New Excel.Application
Dim I_XlsBook As Excel.Workbook
Dim I_XlsSheet As Excel.Worksheet
'数据输出对象
Dim O_XlsApp As New Excel.Application
Dim O_XlsBook As Excel.Workbook
Dim O_XlsSheet As Excel.Worksheet
'打开数据源
Set I_XlsBook = I_XlsApp.Workbooks.Open(Text1.Text)
Set I_XlsSheet = I_XlsBook.Worksheets(1)
'打开接收源
If Check2.Value = 1 Then
O_XlsApp.Visible = True '显示出来
End If
Set O_XlsBook = O_XlsApp.Workbooks.Add
Set O_XlsSheet = O_XlsBook.Worksheets(1)
Dim RG As Range
Dim val As Variant
Set RG = Worksheets("Sheet1").Range("A1:C3") '取出A1~C3内容
val = Worksheets("Sheet1").Range("A1:C3").Value '取出A1~C3值
Worksheets("Sheet1").Range("A6:C8").Formula = RG.Formula
Worksheets("Sheet1").Range("A6:C8").Formula = val
Private Sub Command1_Click()
Dim eApp As Excel.Application
Dim eBook As Excel.Workbook
Dim eSheet1 As Excel.Worksheet
Dim eSheet2 As Excel.Worksheet
Set eApp = CreateObject("Excel.application")
Set eBook = eApp.Workbooks.Add
Set eSheet1 = eBook.Worksheets(1)
Set eSheet2 = eBook.Worksheets(2)
With eSheet1
.Cells(10, 1) = "A"
.Cells(11, 2) = "B"
.Cells(12, 3) = "C"
eSheet2.Range("C3:E5").Value = eSheet1.Range("A10:C12").Value
End With
eApp.Visible = True
End Sub